undefined

Would you mind posting a (sanitized) version of your Power Query code?  You can get it from the Advanced Editor window.  Has anything changed recently in your queries? And if so, did you re-publish all the way through?

Hi MM12345 ,

Please try the following steps:

1.Update gateway to latest version.

2. Make sure you have the same privacy level security in Power BI Desktop and Power BI Service.

•     In Power BI Desktop:Options and Settings --> Data Source Settings --> For every Datasource --> Edit Permissions  --> Set Privacy Level: e.g. „Organizational“
•     In Power BI Service: Datasets --> (Choose you Datasets which does not update properly) --> settings --> Gateway Connection --> Actions --> (expand you cluster to show all Data Sources) --> (Choose relevant Datasource) --> Advanced Settings --> Privacy setting --> set same level (e.g. „Organizational) as in Power BI Desktop.

3.If you combine to many sources in one query,please split it to different queries and it runs again.

If these do not make sense , please tell us your data source and some more details.

Refer to:

https://community.powerbi.com/t5/Service/data-gateway-cluster-and-failed-refresh-quot-Unable-to-connect/m-p/1662238

https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-sql-tutorial

https://community.powerbi.com/t5/Service/Unable-to-refresh-in-Power-BI-Service-Microsoft-Data-Mashup/m-p/1275765

https://community.powerbi.com/t5/Service/Having-problems-with-connecting-MS-Access-accdb-to-the-On/m-p/897213

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi MM12345 ,

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution to make the thread closed. More people will benefit from it.

Hope to hear from you😀

Best Regards,
Eyelyn Qin