Analysis in Excel with already designed Power BI reports

Anonymous — Fri, 22 May 2020 06:03:31 GMT

Hi,

I'm searching a way to just export the report which has been designed in Power BI report to excel.

But seems it's not convenient by using analysis in Excel function. It will only export the data into a blank pivot in excel.

I also found one way to use Power BI publisher add-in in excel to connect to the Power BI report.

Is that possible to use Power BU publisher to display the same report in excel ? And where I can download the add-in ?

Thanks!

Jack

Re: Analysis in Excel with already designed Power BI reports

d_gosbell — Fri, 22 May 2020 06:48:14 GMT

Anonymous wrote:

I'm searching a way to just export the report which has been designed in Power BI report to excel.

But seems it's not convenient by using analysis in Excel function. It will only export the data into a blank pivot in excel.

No you can't export a report to Excel. You can export the data behind a single visual to Excel or CSV. But you cannot export a whole report.

I also found one way to use Power BI publisher add-in in excel to connect to the Power BI report.

Is that possible to use Power BU publisher to display the same report in excel ? And where I can download the add-in ?

Power BI publisher let you go the other way. You could publish an Excel report to PowerBI.com, but it did not let you bring a Power BI report into Excel. And I'm not sure if that add-in is available anymore I think I heard it was retired, and all the links now just take you to the Analyze in Excel documentation.

topic Re: Analysis in Excel with already designed Power BI reports in Report Server

Analysis in Excel with already designed Power BI reports

Re: Analysis in Excel with already designed Power BI reports