Forum Discussion
jonathanbierach
Oct 18, 2024Copper Contributor
Live connection to Power BI dataset is no longer working after latest update
Hi 🙂 After I updated excel/office365 existing files in excel with a live connection (but also new) are no longer working. All permissions are unchanged so I cant really figure out what is causing this.. The option for "Users can work with semantic models in Excel using a live connection" is also enabled for the entire organization. Are there any other users experiencing these same challenges? or is this issue "local" for us?
When I try to export a new file:
When I open an existing file:
- jonathanbierachCopper ContributorFor some added context the datasets are on a different domains then the main office365 from my company and when I upload the relevant excel-file into a sharepoint location on the same domain I am able to refresh it in the web interface. However, if I download this file locally and open it in desktop it no longer works and I am getting the errors which I have added screenshots to. This is an issue that came with the latest update.. So I guess the question becomes how can I overcome this access issue? because I am unable to find an option in Excel where I can change the connection properties like you can in Power BI.
One of our users has the same problem. So far didn't find the reason, in process.
- davejeromeCopper ContributorHi, I was just wondering if you ever found a resolution to this ?
Thanks