Skip to main content
Microsoft Idea

Power BI

Needs Votes

dataset desktop

Vote (469) Share
's profile image

on 19 Apr 2016 15:59:28

Power BI desktop is so very very useful, but is undermined a little by the fact that if you use Power BI desktop want to publish multiple reports, you end up with redundant datasets.

In an ideal world:
a) you should be able to publish a dataset from Power BI desktop - without a report. I have done this with a nearly empty report page and then deleted the report.
b) then you should be able to add reports that use that existing dataset. Unfortunately, this can only be done with the online editor at present. It is essential people can travel with this data and Power BI desktop should be able to use an online datasets and reuse it rather than having to reconnect back to the original source e.g. SQL server.

This is also important for a few reasons:
*) this is currently the only way to get a backup of reports
*) offline working - I often write reports while commuting and so can only use Power BI for that
*) this would then allow offline editing using Power BI desktop, but stop the build up of duplicate data sets from happening
*) it would also stop the unnecessary extra storage and redundant SQL queries from being needed

Comments (11)
's profile image Profile Picture

Niels Shared on 30 Aug 2023 10:23:45

RE: dataset desktop

This would be a great feature and, in my opinion, makes perfect sense. It would remove the logic of a data model out of a report, making it easier to reuse and to maintain. It feels very illogical to me, to have to open one report to change the dataset while working on my other report that makes use of the same dataset.

's profile image Profile Picture

Paulo Diogo Rodrigues Leão on 22 Jun 2023 15:02:49

RE: dataset desktop

2023 and it's not implemented.

's profile image Profile Picture

Nicholas Archer on 28 Oct 2022 05:44:17

RE: dataset desktop

Please yes, allow publishing only dataset, the current system is very frustrating

's profile image Profile Picture

Lawrence Cooper on 18 Aug 2022 15:29:17

RE: dataset desktop

I agree with suggestion by @Saket

's profile image Profile Picture

Jonathan Mills on 01 Jul 2021 02:18:47

RE: dataset desktop

RE : Jeff Brown - "Looks like this is implemented"


Where? Nowhere i can see....

's profile image Profile Picture

Adam Kruzel on 30 Jan 2021 22:27:13

RE: dataset desktop

I used the publish data functionality in Tableau and think it would definitely be valuable with Power BI.

I like how Tableau gives different options such as:

1. Publish dataset separately
2. Publish dataset and connect report to data on the server

's profile image Profile Picture

Anthony Kell on 06 Aug 2020 09:48:24

RE: dataset desktop

At my business we created a master template in desktop which has all our data joins thats are most common, we then publish this. See possible solutions to A & B below:

A) Then via the desktop, select "Get Data" & search "Power Bi Datasets". You can then select that master template and avoid creating a new dataset per report.

B) Then i believe if you are online you can also save a copy of the template and start a new report of the same dataset.

's profile image Profile Picture

Aaron C on 05 Jul 2020 23:55:44

RE: dataset desktop

I would suggest doing like Access. Have a Split button that enables splitting the pbix file in to front end and back end.

's profile image Profile Picture

Saket on 05 Jul 2020 23:00:23

RE: dataset desktop

Users should be able to publish just Dataset using Power BI Desktop. Actually it should ask User

1. 'Publish DataSet' (Only Publish Data Set)
2. 'Publish Report' (Publish Report with Data Set)

's profile image Profile Picture

Kristinn Thor Sigurjonsson on 05 Jul 2020 22:58:40

RE: dataset desktop

I have 3 datasets that have a few common dimensions. I would like if I could merge or join the datasets so that for example the date dimension would work for measures from all datasets.