Forum Discussion
Mixed Model - DirectQuery may not be used with this data source
v-dineshya Yes - the issue was actually in Snowflake. See this resolution here.
https://community.snowflake.com/s/article/Unable-to-authenticate-to-Snowflake-from-Power-BI-We-couldnt-authenticate-with-the-credentials-provided
Hi dkernen2 ,
Thank you for reaching out to the Microsoft Community Forum.
Please check below things to fix the issue.
1. Power BI Service requires an On-premises data gateway for DirectQuery connections to Snowflake. Even though Snowflake is cloud-based. Check the gateway is installed and running. It’s configured to connect to Snowflake. The credentials used in the gateway match those used in Desktop.
2. Power BI introduced a new implementation of the Snowflake connector. If your model was built using the older version, it might not behave the same in the Service. check below thing.
Open Power BI Desktop. Go to File > Options and settings > Options > Preview features. Check if the new Snowflake connector is "enabled".
3. Power BI Service has stricter rules for mixed models. Even if only one table is DirectQuery, the entire model must comply with DirectQuery constraints. Some features or transformations that work in Desktop may not be supported in Service.
4. Ensure that the Power BI Service account has access to Snowflake and there are no IP restrictions or firewall rules blocking the connection.
5. Try rebuilding the semantic model using the new Snowflake connector and re-publishing it. Sometimes, legacy metadata can cause compatibility issues.
Please refer Microsoft Official document and community threads.
https://learn.microsoft.com/en-us/power-query/connectors/snowflake
Solved: DirectQuery error: DirectQuery may not be used wit... - Microsoft Fabric Community
https://community.fabric.microsoft.com/t5/Desktop/Power-BI-Service-Snowflake-Error/td-p/4714501
If my response has resolved your query, please mark it as the "Accepted Solution" to assist others. Additionally, a "Kudos" would be appreciated if you found my response helpful.
Thank you
Thank you for your reply. I have been testing, which is the reason for my tardy reply. It appears I may have an issue on my hard drive, so I am having to wipe my existing machine. I have tested the functionality with other laptops and have not received errors. I was able to connect and use the DirectQuery without the gateway. One necessary step was to disable the Snowflake connector preview issue.
Hi dkernen2 ,
As you mentioned in the previous reply, you are able to connect and use the DirectQuery without the gateway. And if you have any further query do let us know.
If my response has resolved your query, please mark it as the "Accepted Solution" to assist others. Additionally, a "Kudos" would be appreciated if you found my response helpful.
Regards,
Dinesh
v-dineshya Yes - the issue was actually in Snowflake. See this resolution here.
https://community.snowflake.com/s/article/Unable-to-authenticate-to-Snowflake-from-Power-BI-We-couldnt-authenticate-with-the-credentials-provided