Forum Discussion
Issues in Analyze functionality in Excel
Good morning
So far, the links that are created from Power BI service when using the Analyze functionality in Excel have worked correctly for us. Since a few weeks ago, errors have begun to appear in these Excel files that we have connected to the Power BI datasets, such as the one below:
Reading in some post, it seemed that it could be a gateway problem so I updated it to the latest version, but it has not worked. Has anyone encountered this problem or knows how to solve it?
Thank you
6 Replies
Syndicate_Admin , Please share the error in text format
Also check if any issue is reported https://community.powerbi.com/t5/Issues/idb-p/Issues
The error is as follows:
"We couldn't get the data from an external data source. Please try again later.
If the problem persists, contact the administrator of the external data source.
The error message returned by the scanning server named pbiazure://api.powerbi.com is as follows:
. A connection to the wabi-north-europe-l-primary-redirect.analysis.windows.net server may not be established, or Analysis Services may not be running on the specified computer."
Hi JoseLuis71 ,
There're some considerations and limitations below.
Two points I circled could be the cause of the problem. Please check.
Similar post:
Solved: Analyze in Excel Error: MaxPacketLimitReached - Microsoft Power BI Community
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you but the dataset uses Import mode and it's not an external user. Few weeks ago, we could work correctly, but now we have some errors.
Regards
