Solved: Cloud Dataset connection fail

amartin141 · ‎01-03-2023

I connect to company Power BI datasets (2) from my desktop and everything had been displaying fine in Service last week.

I logged into the Service today and i now receive this error message for each dataset connection - can anyone help???

Connections still work fine in desktop - very strange (to me)

We have no on-prem or other gateways that we maintain - just the connections to published pbi datasets.

The total error message (and thank you in advance):

Processing error: There is no available gateway.
Cluster URI: WABI-US-EAST-A-PRIMARY-redirect.analysis.windows.net
Activity ID: c0ef93cb-4251-415c-a9ad-2c86c9a70b23
Request ID: f7f0c943-0aa6-4aa9-9955-c3998104c8ff
Time: 2023-01-03 19:01:25Z

amartin141 · ‎01-03-2023

OK i figured it out (sortof). The report is connected direct query to a pbi dataset. that works fine.

If I add a local table to the report and create relationships between a column on the local table AND the pbi external dataset, I receive that error above on the Service (not desktop). Very interesting. Does anyone have a recommended reading list for combining the use of links to pbi datasets in the Service and also using local tables in a report?

Thanks for reading!

View solution in original post

amartin141 · ‎01-03-2023

Apparently I'm stupid. I cant have a composite model with pbi datasets and imported tables....

amartin141 · ‎01-03-2023

OK i figured it out (sortof). The report is connected direct query to a pbi dataset. that works fine.

If I add a local table to the report and create relationships between a column on the local table AND the pbi external dataset, I receive that error above on the Service (not desktop). Very interesting. Does anyone have a recommended reading list for combining the use of links to pbi datasets in the Service and also using local tables in a report?

Thanks for reading!