Forum Discussion
Excel live connection export issue
Hi simonefraquelli -The Excel version you are using is updated to the latest version. Compatibility issues between older versions of Excel and Power BI Service could lead to problems when attempting to connect to live data.
Power BI Service should also be updated regularly by Microsoft, so ensure that the issue is not related to an older or problematic build.
To diagnose whether the issue is with the dataset or report itself, try exporting a simplified report with a small dataset to Excel using the same method. If this works without errors, there may be issues with the specific dataset size or configuration you're working with.
similar issue, you can refer to these documents:
https://docs.microsoft.com/en-us/power-bi/desktop-troubleshooting-analyze-in-excel#forbidden-error;
https://docs.microsoft.com/en-us/power-bi/service-analyze-in-excel#requirements.
or As an alternative approach, you can use the Power BI REST API to automate the export of data to Excel or CSV formats. This method can bypass some of the issues encountered in manual export processes.
Hope the above information and solved links helps.
Hi rajendraongole1 , we are using Microsoft Office Professional 2019 updated to the latest version and this version was working fine unitil a few days ago.
I tried to export the data from a smaller dataset and the issue has remained.
The tenant settings in article nr. 2 were all enabled.
The API solution will not solve the issue beacause our customers need to export manually the data from PowerBI Service.
Hi simonefraquelli ,
You can extract data and deliver it to your end users using power automate flow with the help of run a query against a dataset, Parse json, create CSV table and send email notification blocks.Even it's possible to send dynamic data by mapping parameters in your users tables.
I hope it will be helpful.
Thanks,
Sai Teja
