Forum Discussion

kevhav's avatar
kevhav
Icon for Continued Contributor rankContinued Contributor
8 years ago
Solved

Download report with Power BI Service live connection?

Say I publish a dataset to the Power BI Service. Then, in the Power BI Service, I create a new report based on that dataset.   Now, say I open that report in the Power BI Service, and then click "F...
Need Help
  • als987's avatar
    als987
    8 years ago

    Hi,

     

    I came across this post as I had the same problem myself, and have found a fairly straightforward solution to it.

     

    I found this blog post here about SQL Server live query, but I tried it and the same can be applied for Power BI service dataset as well:

     

    https://ruiromanoblog.wordpress.com/2018/02/01/convert-a-power-bi-desktop-report-from-import-to-live-query/

     

    Essentially you need to:

     

    1. Download the PBIX file (which will be a full PBIX file with a copy of the dataset)

    2. Open Query Editor and delete absolutely everything, then close and apply. Expect to see errors in all of your visuals, but don't worry.

    3. Choose Get Data and connect to the desired PBI service dataset. (Make sure that there aren't any tables left or PBI will say that there is an existing dataset - even though I had deleted all queries in the Query Editor I still had one parameter table left which I had to delete from the Tables view.)

     

    If all goes well your visuals will all work correctly and you will be connected to your PBI service dataset. 

Lorentzt's avatar
Lorentzt
Frequent Visitor
8 years ago

I have a similar problem. I have 3 diferent reports based on the same data and each is duplicated many times.

 

As it is now i have to create them from scratch if i want to create templates for usage from the Power BI Desktop. So if you create a sugestion point me in the correct direction and ill support it.