Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
My sheduled refresh started failing, after I published a new versions that used the Merge Query to add 3 columns from a SQL database table, for wich I already have a gateway and that table has worked for the last two years so can't be a gateway issue. I merged the columns from a SQL table (wich uses the Import data option), to the table that comes from an Excel spreadsheet in SharePoint Online (called sd_ClientSurveyResults). Now I keep getting this error when it tries to refresh:
{"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 refresh is not allowed in gateway setting."}}],"exceptionCulprit":1}}} Table: sd_ClientSurveyResults.
No gateway is needed when using SharePoint Online or Excel Online and the SQL database does have a gateway that works so not sure why this is happing.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @Analyst-Rene ,
Based on your description, for merged data sources.You need to make sure you have enabled cloud source refresh in your gateway settings.Merge or append on-premises and cloud data sources - Power BI | Microsoft Learn
Best regards,
Community Support Team_ Scott Chang