Skip to main content

Power BI

Under Review

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

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

d457d2b1 d2c1-4b2e-b9e3-aa68f463660f 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

51603fe4 14c0-455d-9082-11f708c9df9c 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

f2ae5f0d 18d3-4bcf-9708-cf6c0f115c0c 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

f712906d 4fd7-4760-b718-eeb7df188dc2 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

0c522f80 6ec8-499a-8343-5fe60f298c56 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

290dfd97 2467-4fb8-bb50-92c761a445bd 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

0bed460f 2f61-473a-8c94-6658cabceb49 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

37906af5 3f35-4073-a801-121bd9d67451 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

0672a81b 795b-46ab-bc3d-dc8840d04242 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

2ab490d7 613f-4001-888f-7b6b4f86605e 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