Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

aleckealey18

Snowflake Connector in Power BI Desktop not showing Information Schema

Submitted by on ‎09-14-2023 12:52 PM

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
See more ideas labeled with:
2 Comments (2 New)
Comments
Anonymous
Not applicable
‎09-14-2023 11:51 PM

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
‎09-15-2023 09:58 AM

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. 

Idea Statuses