topic Trouble Connecting to Data Sets in Excel in Developer

Trouble Connecting to Data Sets in Excel

The_Marc_Rohde — Thu, 21 Apr 2022 15:13:37 GMT

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.

Re: Trouble Connecting to Data Sets in Excel

Anonymous — Mon, 25 Apr 2022 05:21:54 GMT

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