Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Snowflake Connector in Power BI Desktop not showing Information Schema

I have a user that is trying to connect to SNOWFLAKE in Power BI Desktop through the built in connector. They are not able to see the INFORMATION SCHEMA but can see everything else.

 

They have connected to snowflake in Power BI Desktop through ODBC and it works fine. The built in snowflake connector does not show it for some reason. 

 

We want users to use the connector so they can use it on the webservice without the need of a gateway. The only work around currently is they recreated a view of the schema and can see it, it is just an unnessecary and redundant step it feels like. 

 

Any ideas on how to fix this?

Status: Investigating

Hi @aleckealey18 ,

 

Please try updating Power BI Desktop to the latest version. Alternatively, you could try using a different connector, such as the ODBC connector that the user has already successfully used, or a third-party connector that is compatible with Snowflake.

 

Best Regards,

Community Support Team _ Neeko

Comments
v-tangjie-msft
Community Support
Status changed to: Investigating

Hi @aleckealey18 ,

 

Please try updating Power BI Desktop to the latest version. Alternatively, you could try using a different connector, such as the ODBC connector that the user has already successfully used, or a third-party connector that is compatible with Snowflake.

 

Best Regards,

Community Support Team _ Neeko

aleckealey18
Regular Visitor

Yes, we have tried with the updated version and it still does not work. I understand the ODBC method works, we are just trying to not create additional gateways on our servers, since they should be able to use it as a cloud connector without the need for a gateway.