Forum Discussion

ECarwardine's avatar
ECarwardine
New Member
1 year ago
Solved

Power BI Not Loading Snowflake Tables

When trying to "Get Data" from snowflake I am unable to access tables in the usual way. My organisation says they havent changed any setup so I assume this is a coincidence of a PowerBI update to the...
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi ECarwardine ,

    Thank you for reaching out to the Microsoft Fabric Community.

     

    Based on your description, it appears you're unable to access Snowflake tables via Power BI's "Get Data" experience, even after disabling the new Snowflake connector implementation.

     

    To troubleshoot this, we recommend first ensuring that the Role, Warehouse, and Database are explicitly specified in the connection settings, as relying on defaults may result in limited visibility. Please also verify table access by logging into the Snowflake Web UI using the same credentials if tables aren’t visible there, it’s likely a permission or role assignment issue.

     

    Additionally, clear any saved credentials in Power BI under Data source settings, and ensure you’re using the latest Power BI Desktop version. If you're connecting through an ODBC-based setup, make sure the Snowflake ODBC driver is version 2.25 or later. Lastly, we suggest testing both the new and legacy connector modes, as behavior can vary.

     

    I hope this will resolve your issue, if you need any further assistance, feel free to reach out.

    If this post helps, then please give us Kudos and consider Accept it as a solution to help the other members find it more quickly.

    Thankyou.