Solved: Trouble Connecting to Data Sets in Excel

The_Marc_Rohde · ‎04-21-2022

I have one user who is getting an error when using "Get Data>From Power BI" and it only appears to be happening in one system.

They can get to Power BI web without any issues so we know there is at least internet connectivity. I'm trying to figure out what else can be done.

We have upgraded Office after the issue arise and downloaded the "Analyze in Excel" updates as well and neither has addressed the issue for them.

Anonymous · ‎04-24-2022

Hi @The_Marc_Rohde ,

This is a known issue and has been reported internally(ICM:301218128). The related engineer is working on it, any progress I will update you asap. As a workaround, customer can navigate to the Power BI datasets hub and search for the dataset they need to connect to and click Analyze in Excel to generate an Excel workbook connected to the Power BI dataset.

Best Regards

View solution in original post

Anonymous · ‎04-24-2022

Hi @The_Marc_Rohde ,

This is a known issue and has been reported internally(ICM:301218128). The related engineer is working on it, any progress I will update you asap. As a workaround, customer can navigate to the Power BI datasets hub and search for the dataset they need to connect to and click Analyze in Excel to generate an Excel workbook connected to the Power BI dataset.

Best Regards