Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
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;
I have created connections for the Cloud connections table
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
Solved! Go to Solution.
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
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
49 | |
28 | |
20 | |
20 | |
19 |
User | Count |
---|---|
52 | |
51 | |
26 | |
26 | |
22 |