DM_GWPipeline_Gateway_MashupDataAccessError

Hi data_wizard_NOT ,

Thanks for reaching out to the Microsoft fabric community forum. 

Here are some steps to troubleshoot:

Check the Data Gateway: Ensure the data gateway is online and properly configured.
Go to Power BI Service > Settings > Gateways and verify the status of the gateway. Check if the gateway is shared correctly if it's a cluster.

Gateway Connection Configuration: Even though you didn’t change the data source, sometimes updates can alter connection settings. Re-check the Data Source Settings in the Power BI Service. Verify that the Snowflake connection in the Power BI service matches the credentials and connection settings from Desktop.

Snowflake Connection Issue:

The error mentions "Adbc.DataSource" not being available. This could be due to:

Driver Issues: Ensure the correct Snowflake ODBC driver is installed and updated on the gateway machine.

Version Mismatch: Compare the Snowflake driver versions between the desktop and the gateway.

Query-Specific Issue: Since only Query2 is failing, inspect this query in Power BI Desktop:

Look for any custom functions, complex joins, or transformations that might behave differently in the service. Try simplifying the query temporarily to see if the error persists.

Refresh Settings in Power BI Service:

Sometimes, scheduled refresh settings can behave differently from manual refreshes. Check the refresh schedule and error settings. Try triggering an on-demand refresh from the service and monitor if the error reappears.

Permissions:

Even if permissions haven't changed, double-check that the service principal or user credentials used by the gateway have the correct access to Snowflake.

Error Logging:

In the Power BI Service, go to Dataset Settings > Refresh History for detailed logs. You can also check the gateway logs on the server where the gateway is installed for more insights.

Please refer the below article.

Troubleshoot gateways - Power BI | Microsoft Learn

If you find this post helpful, please mark it as an "Accept as Solution" and consider giving a KUDOS. Feel free to reach out if you need further assistance.
Thanks and Regards