Forum Discussion
Viewing Excel Workbook in the Service
Hi Anonymous ,
Can you connect to excel in a different way? Reference to the following document connection is helpful to you.
Publish to Power BI from Microsoft Excel - Power BI | Microsoft Docs
Power BI May 2021 Feature Summary | Microsoft Power BI Blog | Microsoft Power BI
If the problem is still not resolved, please point it out. Looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you Henry,
I have tried publishing from Excel Desktop in the past, but that method reduces the ability to adjust the workbook after it is published, at least until you republish. With Excel Online, changes are effective immediately. Both ways have pros and cons, but for my use case having the flexibility of making quick changes is important.
I think the data refresh issue might be more of an Excel problem than Power BI. The error leads me to this support page: https://support.microsoft.com/en-us/office/refresh-an-external-data-connection-in-excel-1524175f-777a-48fc-8fc7-c8514b984440?ns=xlwaenduser&version=15&ui=da-dk&rs=da-dk&ad=dk#ID0EBH=Web
The occasional blank page might be fixable by clearing the cache, but that will be difficult to enforce in my organization...
Thank you for you help.
Best regards,
Jacob