Forum Discussion

jonathanbierach's avatar
jonathanbierach
Copper Contributor
Oct 18, 2024

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:

 

 

 

 

  • jonathanbierach's avatar
    jonathanbierach
    Copper Contributor
    For 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.
  • davejerome's avatar
    davejerome
    Copper Contributor
    Hi, I was just wondering if you ever found a resolution to this ?
    Thanks

Resources