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
13 Comments
- rmaloneNew MemberAdded the following idea which is related: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/18019666-datset-as-a-data-source
- kristinnsNew MemberI 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.
- skrishna1New MemberUsers 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)
- aaron_s_creightNew MemberI would suggest doing like Access. Have a Split button that enables splitting the pbix file in to front end and back end.
- anthony_kellNew MemberAt 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.
- akruzel2New MemberI 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
- jonathan_millsNew MemberRE : Jeff Brown - "Looks like this is implemented" Where? Nowhere i can see....
- fbcideas_migusrNew Member
I agree with suggestion by @Saket
- Nicholas_ARCHERNew Member
Please yes, allow publishing only dataset, the current system is very frustrating
- diogo_leaoNew Member
2023 and it's not implemented.
Recent ideas
Enable Analyze in Excel Without Build Permissions on Power BI Semantic Models
Description: Currently, Power BI requires users to have Build permissions on a semantic model to use the Analyze in Excel feature. However, this permission also grants users the ability to create new...Anonymous1 hour agoNot applicableNew3.8KViews25likes1CommentPower BI Import Mode Limitations with Databricks Metric Views
Hi, OVERVIEW We are working on a large-scale reporting modernization project using Databricks Metric Views as a centralized semantic layer for Power BI. We have successfully tested Databricks Metr...Bhuvanaa2 hours agoNew MemberNew7Views0likes0CommentsEnable native Power BI integration with Databricks Metric View
Today, Power BI semantic models (datasets/DAX) work well when Power BI is the only BI tool. However, many organizations use Databricks as their lakehouse and need consistent, governed metrics across ...dhaneswara2 hours agoNew MemberNew29KViews825likes65CommentsRestore "no-reply" option for Power BI Subscriptions
Please add a setting in the Power BI Subscription pane to choose the sender identity. With the recent update the platform forces emails to route through the subscription owner's personal Exchange On...LenaFid3 hours agoRegular VisitorNew476Views80likes16CommentsFabric schedule as a separate item
I'm using pipelines with schedules. This works for me. But whenever I change a schedule, the pipeline appears as Uncommitted in the Fabric UI, and Source control tells me I've changed the pipeline....Reitse4 hours agoMost Valuable ProfessionalNew3Views0likes0Comments