Excel with Power BI data crashes for free users

Question

Hi everyone,&nbsp;I, as a Power BI Pro user, created an excel file, that has a bit of data from my Power BI dataset in pivot tables through "Get Data -&gt; From Power Bi". Then I uploaded this excel file to sharepoint and shared it with my colleagues, who are normal free users or not invovled with Power BI at all.&nbsp;It was my understanding they could still access and work normally in this excel file, just not refresh the pivot tables, since they have no access to my Power BI workspace.&nbsp;And if they open the sharepoint file in browser or teams, it seems to work, but as soon as they open it in the desktop app, excel crashes for them.&nbsp;Am I wrong in my understanding or is there another issue at hand?&nbsp;Thank you for your help!&nbsp;

hambach · Answer

And some people can open and edit it, but excel crashes when they hit save

rubayatyasmin · Answer

Hambach&nbsp;&nbsp;these answers should be helpfulExcel file closes immediately/crashes when opened from SharePoint - Microsoft Community&nbsp;Excel desktop app crashes when opening file from sharepoint online - Microsoft Community&nbsp;

hambach · Answer

Thank you for your quick reply, but unfortunately these did not work.

hazenm · Answer

Hambach&nbsp; did you ever find a solution?&nbsp;I'm having this same issue with users that have licenses. About a third of my users, who all have licenses, get random crashing whenever using my Power BI Excel files. Tried disabling background refreshes on all of the connections to no avail.&nbsp;

hambach · Answer

Hi, unforutnately not 😞 Same issue still. If you ever find a solution, let me know. Will do likewise.

Forum Discussion

Excel with Power BI data crashes for free users

6 Replies

Related content

Power Query in Excel / all Power Query related commands in Excel cause crash of Excel

Excel Crashes in Table Properties

Develop Power Query outside Power BI or Excel

Power BI Desktop crashing on save

Powerbi Crashes