Convert a Power BI Desktop report from Import to Live Query

Recently I came across this great blog post from Dustin Ryan on how to convert a Power BI Desktop File from Import to Live:

https://sqldusty.com/2018/01/30/converting-a-power-bi-desktop-file-from-import-to-live-query/#comments

But I’ve been using another technique that is very simple and don’t require any external tools, you just need to execute 5 simple steps in Power BI Desktop:

1. Open the PBIX with Power BI Desktop

2. Open the “Query Editor”, select all the Queries and click on “Delete”:

image

3. Click on “Close & Apply”:

image

And you will end up with something like this:

image

4. Now click on “Get-Data” and “Analysis Services”:

image

5. Write down the Analysis Services (or Azure Analysis Services) server address, Database Name and click on the option “Connect Live”:

image

And that’s it!

If your Analysis Services model has the same fields and measures the report will work just fine and now your PBIX is converted from “Import” to “Live”:

image

Advertisements

2 thoughts on “Convert a Power BI Desktop report from Import to Live Query

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s