Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Allow Power BI Designer to open a Dataset or Report published in online Power BI repository

If you setup a data source using the Power BI Analysis Services Connector that shows up in the Power BI online Dataset repository you should allow the use of that dataset directly from the Power BI Designer. This will allow you to publish reports using the already shared dataset and it also gives you a better experience querying a tabular data source then the Power BI Designer does now when connecting directly to the tabular instance. I would say this should also apply to any other 3rd party data source created there for the likes GitHub, Salesforce, etc. You should also be able to open reports that have been published and edited in the service in the same way.
Status: Under Review
Comments
nishalit
New Member
We are currently working on the support to re-open pbix files from desktop.
bjoern_sjut
New Member
Just to add to this: We have the need to be able to edit datasets that have been populated via Power BI's REST API. A typical issue is that after pushing data in via the REST API, we need to fine tune some data points (e.g. different "kinds" of blanks. It's currently not possible to iron out these kinks in the data when stuff is published directly to a PowerBI data set via the REST API.
martinterhorst
New Member
We'd love to be able to pull down a report or dashboard from the service into the desktop application for advanced editing, and then republish it. We could then truly collaborate on report and dashboard design both in the service as well as on the desktop
jeremyfirth
Advocate II
I made a report in Power BI Desktop, then published it. I made some changes on PowerBI.com to it by editing the report. Now when I open the pbix file, those changes aren't reflected, and I don't see any way of sending those changes from powerbi.com back to PowerBI Desktop. ARGH!
pawel_potasinsk
New Member
I would say the same is about reports - I don't see a way to effectively maintain (edit) the reports because I need the original .pbix / .xlsx file. Instead you could allow to open published datasets and reports in Power BI Desktop and Excel.
paulc1
New Member
Its very strange that the Power BI Designer can't work with Power BI data sources - I would have expected it to have been the first data source supported. We too have created data sources using the REST API and the limitation is very frustrating.
j316
New Member
Glad this is planned. This feature is essential to modeling of datasets that originate with the REST API or as ASA Outputs.
mstefancik
Advocate IV
Any news on this topic? As it is on radar since January 23.
AshwiniSaraf
New Member
In my scenario, I have many members added in the group .but we want only admin can edit the report and rest all should only view the report. but Power BI is giving editing option to each and every member added? kindly help on this
john13
New Member
Key question in my mind is how to handle the following senario: if a dataset was published by a user and later IT move the database to another server, how would they get access to the PowerBI dataset to change the connection details – especially of the original user has left the company. Seems the feature requested here would help