Skip to main content

Power BI

Planned

Updatable PBIX/XLSX datasets

Vote (55) Share
Burt Bielicki's profile image

Burt Bielicki on 14 Feb 2015 06:46:18

A way to update datasets (so reports we can add new calculated fields, etc.). If that was fixed, I think my team could begin adopting

Administrator on 17 Feb 2015 10:01:13

Hi there! We're working on this right now! You'll see it in a future release!

Comments (5)
Burt Bielicki's profile image Profile Picture

1dc65cff 4723-48fb-90d6-aa885036c668 on 05 Jul 2020 23:40:18

RE: Updatable PBIX/XLSX datasets

When source file on e.g. on SharePoint moves to another location (folder) then when you chnage and publish the pbix file you get a new dataset.

Why cannot one edit the source location of a dataset directly ?
(current not using a Professional license)

Burt Bielicki's profile image Profile Picture

028b0aad b0c4-48e0-8ce4-514ade883697 on 05 Jul 2020 22:40:16

RE: Updatable PBIX/XLSX datasets

This relates to the following other Ideas:

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/13478433-dataset-desktop

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/11081736-avoid-redundancy-of-datasets-same-source-2-data

We need a way to publish a Dataset and then use this Dataset as a Data Source. This would then allow Desktop to build Reports, add Calcs, and Join other Data with a Dataset.

Burt Bielicki's profile image Profile Picture

13014ee8 fe25-46a4-aa25-9898d90ca1ef on 05 Jul 2020 22:38:38

RE: Updatable PBIX/XLSX datasets

Yes it's a challenge for me. I have one report template that I need to pass to different areas of the business. I was hoping to import a PBIX file and then use the API to clear and push data.

Burt Bielicki's profile image Profile Picture

12a8cad4 b58c-4201-b098-a279a8816179 on 05 Jul 2020 22:01:29

RE: Updatable PBIX/XLSX datasets

Would love to see that feature released soon! Here's a post that describes my irritation with the current workflow, maybe it has some input on a good expected behavior: https://support.powerbi.com/forums/265200-power-bi/suggestions/7093112-updatable-pbix-xlsx-datasets

Burt Bielicki's profile image Profile Picture

fd16c560 652e-4669-92fd-699ce61d4310 on 05 Jul 2020 22:01:24

RE: Updatable PBIX/XLSX datasets

This has been challenging for me as well.