Skip to main content
Microsoft Idea

Power BI

Planned

Updatable PBIX/XLSX datasets

Vote (57) 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

WillyV@DXC 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

ray malone 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

Alex Thompson 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

Bjoern Sjut 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

ben.jenkins on 05 Jul 2020 22:01:24

RE: Updatable PBIX/XLSX datasets

This has been challenging for me as well.