Getting "Failed to Load Data Sources" error in powerbi.com

[ianmariano]

We are not admins of our PowerBI tenant, so posting here...

This is happening for several datasets for reports we have published to powerbi.com. Managed Gateways shows the gateways for these as connected, but when we view settings for the datasets we get the error "Failed to Load Data Sources", example error contents:

• Activity ID189c5e82-37f6-4fb2-a35f-511274a75d8d
• Request ID771dad27-7197-eb60-5a8c-180fb1598c86
• Correlation ID9e0907ad-0a68-2ddb-1032-351cfe5a83a6
• Status code404
• TimeMon Feb 01 2021 17:26:22 GMT-0500 (Eastern Standard Time)
• Service version13.0.15255.54
• Client version2101.3.04559-train
• Cluster URIhttps://wabi-us-north-central-f-primary-redirect.analysis.windows.net/

Please note, we have tried deleting the reports, then re-publishing. They will work for a time, then the above error starts occurring again.

[collinq]

Hi @ianmariano ,

You mentioned that you are not the tenant admin, you may be able to do a few things but if this keeps coming up, you may end up needing a ticket.  Since you can get to the gateways, when you try "test connection" it works fine?  If so, then that leads me to believe that the issue could be in the report.  

If it is the report, can you confirm that the desktop file and the gateway are both updated with the latest and greatest versions?  (They often need to be in sync for everything to work correctly long term.)  Also, does your report have anything "interesting" in it that might be causing a hiccup - like ODBC connectors or R script or other connections that require bits to be installed on the gateway machine?