Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply

Excel live connection export issue

Hello,

i would like to report a problem we encountered after the exportation of an Excel file with live connection from Summarized data method in PBI Service.

 

simonefraquelli_0-1727965018556.png

 

With every file we export and open with this method after the "Enable Content" step we encounter the following error, before being able to insert the log on credentials:

 

simonefraquelli_1-1727965118823.png

 

We ecounter this error with every customers in totally different PowerBI apps.

Any suggestions?

Best regards, Matteo.

12 REPLIES 12
mariussve1
Impactful Individual
Impactful Individual

Hi,

After we got Excel 2409 everything is ok again for me. Looks like there was an issue with 2408 version of excel 🙂


Br
Marius
BI Fabrikken
www.bifabrikken.no
mariussve1
Impactful Individual
Impactful Individual

Hi all,


We are experiencing exactly the same issue. Suddenly, live connections to Excel have stopped working. This happened after we received an update to Excel Version 2408 (Build 17928.20216) in Office365.

A colleague of mine who hasn’t updated their Excel yet and is still on Version 2407 (Build 17830.20210) it does work, so it need to be something to do with the latest update!


It’s important that we figure this out, as we have several hundred users relying on this every day!

 


Br
Marius
BI Fabrikken
www.bifabrikken.no

Second this. Exactly the same issue here, with 100+ pissed end users as a result, the same users that I just convinced to move from manual exports to live connection.

 

TL;DR: a resolution would be great 🙂

v-zhouwen-msft
Community Support
Community Support

Hi all,thanks for the quick reply, I'll add more.

Hi @simonefraquelli ,

Regarding your problem, I think there is a problem with the latest version of Microsoft Office Professional 2019 (2409). You can try to roll back the version.

How to revert to an earlier version of Office - Microsoft Support

Also check that these prerequisites are met:

Connect Excel to Power BI semantic models - Power BI | Microsoft Learn

Finally you can try clearing your cache.

vzhouwenmsft_1-1728283326161.png

Hope this helps

 

Best Regards,
Wenbin Zhou

 

Hello @v-zhouwen-msft ,

the issue is still present today, even with with the new Office updates realesed in the last few days...

 

simonefraquelli_0-1729060147495.png

 

I cheked all the requirements were met and i clear the cache but it is still not working with the above Excel version.

Unfortunately the roll back is not an option for us because we can't directly update our customer's Excel version, nor ask them to do so.

Regards,

Matteo

10/29 update.

Issue is still present, even with the new Office version 2410, please help us.

 

simonefraquelli_0-1730218631056.png

 

Regards.

lbendlin
Super User
Super User

If you have a Pro license you can open a Pro ticket at https://admin.powerplatform.microsoft.com/newsupportticket/powerbi
Otherwise you can raise an issue at https://community.fabric.microsoft.com/t5/Issues/idb-p/Issues .

audreygerred
Super User
Super User

Hi! This error is usually associated with permissions or configuration. Can you check with your admins and ensure that exporting data isn't restricted based on roles or permissions? Also, ensure if sensitity labels are applied that they have the appropriate permissions to export with that label applied. Make sure that the model is configured properly in service and the connections are working properly. You can also send the error Activity ID to your admin and ask them to trace the error in the logs and get more details.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





rajendraongole1
Super User
Super User

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.

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





I have the same problem, in the same way I am the administrator user, for what we were seeing with my team is that it is the update of excel (2409), because users who have the previous version (2408) can still make the connection without any problem

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 

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.