analysis in excel

3 Topics

Export to excel automatically
I am using power bi report server (on premise). I need to download power bi report (mostly single table in each report) to be downloaded automatically? can anyone have any suggestion? We dont have power automate
Solved
learner_23
2 years ago Place Report Server
1.2KViews
0likes
1Comment
Error in "Analyze in Excel" option - Failed to connect while attempting to call cluster resolution
We download our Power BI reports in excel using the "Analyze in Excel" option. We were able to download the file and play around the data in excel until last Friday. We haven't upgraded our gateway or no other changes were done. For some reason, we started seeing the following error while opening the excel file that got downloaded after choosing the "Analyze in Excel" option. Error:- Failed to connect to the URL "https://api.powerbi.com" while attempting to call cluster resolution.
Solved
Anonymous
3 years ago Place Report Server
10KViews
1like
12Comments
Analysis in Excel with already designed Power BI reports
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
Anonymous
6 years ago Place Report Server
626Views
0likes
1Comment