Skip to main content
Microsoft Idea

Power BI

Under Review

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

Vote (273) Share
Tom Marek's profile image

Tom Marek on 08 Jan 2015 08:12:27

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.

Administrator on 14 May 2016 04:13:06

We are currently working on the support to re-open pbix files from desktop.

Comments (22)
Tom Marek's profile image Profile Picture

Jeff Garcia on 05 Jul 2020 22:18:14

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

Please update with any news available about this feature.

Tom Marek's profile image Profile Picture

Marc Lelijveld on 05 Jul 2020 22:17:11

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

Is there any news about this topic? Since it's on the radar for over a year!

Tom Marek's profile image Profile Picture

Ian Watkins on 05 Jul 2020 22:16:11

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

Any news on this feature coming along?

Tom Marek's profile image Profile Picture

John Tunnicliffe on 05 Jul 2020 22:14:05

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

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

Tom Marek's profile image Profile Picture

Ashwini on 05 Jul 2020 22:13:16

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

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

Tom Marek's profile image Profile Picture

marian on 05 Jul 2020 22:10:52

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

Any news on this topic? As it is on radar since January 23.

Tom Marek's profile image Profile Picture

Jason Brugger on 05 Jul 2020 22:08:09

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

Glad this is planned. This feature is essential to modeling of datasets that originate with the REST API or as ASA Outputs.

Tom Marek's profile image Profile Picture

Pawel Potasinski on 05 Jul 2020 22:04:59

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

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.

Tom Marek's profile image Profile Picture

Paul C on 05 Jul 2020 22:04:53

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

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.

Tom Marek's profile image Profile Picture

Martin ter Horst on 05 Jul 2020 22:02:43

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

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