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. 

v-huizhn-msft's avatar
v-huizhn-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi kevhav,

If you connect a dataset using import mode, it would be import model when you download the .PBIX copy. While If you connect a dataset using Direct query mode, it would be Direct query when you download the .PBIX copy. The model of .PBIX copy depends on the original model before publishing it to service. 

Until now, there is no way to download the report with a live connection to the dataset on the Power BI Service. You can create a idea here. The product team will consider it if more people need the requirement.

Best Regards,
Angelia