Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
sperry
Resolver I
Resolver I

Web & file datasource models not refreshing through gateway

Hi - I have a scenario that has just starting happening. I have multiple PowberBI reports that I have scheduled refresh occuring. They have a mix of file & cloud sources. There is a new section called Cloud Connections that I haven't seen before. Anyway I have created connections through the gateway and get the green light message at the top of the data connection table;

 

sperry_0-1695854471965.png

I have created connections for the Cloud connections table

sperry_0-1695854784748.png

 

 

But if I refresh I get this error message;

Data source error: {"error":{"code":"Premium_ASWL_Error","pbi.error":{"code":"Premium_ASWL_Error","parameters":{},"details":[{"code":"Premium_ASWL_Error_Details_Label","detail":{"type":1,"value":"Cloud data source setting is not allowed refresh through gateway."}}],"exceptionCulprit":1}}} Table: Live SSST.

Cluster URI: WABI-AUSTRALIA-SOUTHEAST-redirect.analysis.windows.net

Activity ID: 006695b7-eff6-4b66-ab54-76292190e6ab

Request ID: dfe3fdf3-d454-f399-8bf2-d14532eba88d

Time: 2023-09-27 18:27:38Z

 

Checked the Gateway settings and the setting should allow the cloud connections

sperry_2-1695854677717.png

 

 

 

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

4 REPLIES 4
lbendlin
Super User
Super User

You can raise an issue at https://community.fabric.microsoft.com/t5/Issues/idb-p/Issues . If you have a Pro license you can consider raising a Pro ticket at https://admin.powerplatform.microsoft.com/newsupportticket/powerbi

So the solution to this is that there is no solution? 😀

The reality is that there are frequent service changes, and some of these changes break things.  Raising a ticket is the fastest way to get these broken things working again.

Actually, I spoken with MS, and the issue is resolved, in general, we need to either set all the connection to Gateway or Cloud, but not both.. so now the 2 entries are move to the Gateway side (I had to created 2 new on-prem connections) 

In our case the table/query is mixed with On-prem and Cloud, so the Gateway got confused? I guess. Anyway, it's fixed, hopefully this is helpful to others.

 

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Feb2025 NL Carousel

Fabric Community Update - February 2025

Find out what's new and trending in the Fabric community.