Connect live report to a local pbix file

[Kimcha]

Hi,

I am currently creating one dataset that I want to use as the base-model for all my future reports with the "Live Connection to Data Service".

But it's difficult to create a report when you have to re-upload the file with all data after each change to the model.

Is it possible to connect the report to a local PBIX file? My understanding is that each open PBIX file is essentially a locally run SSAS server.

What I'd like to achieve is to...

• Edit one local PBIX file where I make changes to the model (model-pbix)
• Edit another local PBIX file where create a report that connects to the model-pbix (report-pbix)
• Once finished, upload the model-pbix to the PBI service
• Change the report-pbix to use the live connection to the uploaded report
• Upload the report-pbix

Is such a workflow possible? I did quite a bit of googling and it seems this is not supported by default, but maybe there is a hacky way?

Perhaps it could be achieve with these ways: 

https://eriksvensen.wordpress.com/2017/10/03/how-to-change-the-powerbi-desktop-file-connection-from-...

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

But what are the settings to connect to a local PBI report? DAX Studio seems to be able to do it.

[Kimcha]

Awesome, thanks Frank. I am glad this method is working.

But I was asking if it is possible to connect to a PBI document locally without uploading it to the Power Bi Service. Similar to how DAX Studio can connect to a PBI document.

[agnaldocarmo]

I'm looking for the answer to the same question

[v-frfei-msft]

Hi @Kimcha,

Here I made a test, I has two pbix files here, one for model-pbix and one for report-pbix.  Please refer to the following steps.

1. Publish the model pbix to service.

2. Change connection of the report pbix following the guide in the document. Then the connection of the report will be updated to connection of model dataset in Power BI Service .

3. My test result is as below.

Regards,

Frank