Issues in Analyze functionality in Excel

[Syndicate_Admin]

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

[Syndicate_Admin]

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."

[Anonymous]

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.           

[JoseLuis71]

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

[Anonymous]

Hi @JoseLuis71 ,

If you are above a Power BI Pro licensee, you can create a support ticket for free and a dedicated Microsoft engineer will come to solve the problem for you.

It would be great if you continue to share in this issue to help others with similar problems after you know the root cause or solution.

The link of Power BI Support: https://powerbi.microsoft.com/en-us/support/

For how to create a support ticket, please refer to https://community.powerbi.com/t5/Community-Blog/How-to-create-a-support-ticket-in-Power-BI/ba-p/6830...

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.           

[JoseLuis71]

Then I can't create the ticket because I have a Pro Licence, not above. I will keep looking for the solution.

[amitchandak]

@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