How to use an Analyze in Excel pbiazure in a separate Power BI report

[stchln]

Hello

I am exporting data to Excel from a Power BI report and from this Excel I take the pbiazure link, formatted like "pbiazure://api.powerbi.com afe5e6b5-cb44-4408-b9cd-xxxxxxxxxx Model" and I would like to know if I can create another Power BI report using this pbiazure Model as data source?

Thanks for your help

[amitchandak · Accepted solution]

@stchln , not very clear -IF you want power bi dataset as source refer

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-report-lifecycle-datasets

Analyze in excel //external tool

https://www.sqlbi.com/tools/analyze-in-excel-for-power-bi-desktop/

Analyze in excel

https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-analyze-in-excel

also check

https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-may-2020-feature-summary/#_Excel

[amitchandak · Accepted solution]

@stchln , not very clear -IF you want power bi dataset as source refer

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-report-lifecycle-datasets

Analyze in excel //external tool

https://www.sqlbi.com/tools/analyze-in-excel-for-power-bi-desktop/

Analyze in excel

https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-analyze-in-excel

also check

https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-may-2020-feature-summary/#_Excel

[bchager6]

@amitchandak do you know how to get the "pbiazure://api.powerbi.com..." connection string from the Power BI service? I want to repoint an Excel workbook from one source to another.

[Steve_J]

Did you ever find an answer to this? I am facing the same problem of wanting to keep my "template" excel workbook but want to change to different published powerBI workbook

[mcasey]

Did either of you ever figure this out?  I'd also like to do this.  Thanks

[stchln · Accepted solution]

thanks amitchandak, you first link is answering my question. I was trying to export a PBI report to Excel then re-import on another PBI while there is a shortcut, we can directly import one PBI report from another 😉

Stéphane