This is regarding the OLE DB or ODBC error which I am facing while opening a report (Table visual) in Power BI desktop, which is sourcing data from Snowflake views in a direct query mode. I am using the latest Power BI version (August 2023).
Below are the highlights related to the existing issue.
- When I am opening a table visual report in a power BI desktop, I am getting the error.
- When I am opening the same visual report in power BI service (published report), I am not getting any error and I am able to open the report successfully.
- When I tried running the Dax query generated by Power BI in DAX studio, it is throwing the same error.
- There the two separate Power BI reports with the similar table visual and I am facing same error with both the reports, where in I can open the report in Power BI service but not in the Power BI desktop.
Please find the error screen shot mentioned below for your
reference - 1st screenshot is from Power BI and 2nd screenshot is from Dax studio.
I welcome any advice or suggestions anyone may have to offer incase you have come across similar error. Thanks in advance.
@Anonymous I never used Snowflake as a source but cannot you use Snowflake connected rather OLE DB or ODBC?
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Helpful resources
Power BI Monthly Update - September 2025
Check out the September 2025 Power BI update to learn about new features.
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
