Forum Discussion

coverturfLSH's avatar
coverturfLSH
Icon for Resolver II rankResolver II
2 years ago

Single User error trying to pull data from Warehouse in PowerBI

Hi,   I have ONE (1) individual in my organization who is unable to use PowerBI to query the SQL endpoints for any data warehouses/lakehouses in our PowerBI web service.   The error they are gett...
data warehouse
power bi
alfBI's avatar
alfBI
Icon for Responsive Resident rankResponsive Resident
2 years ago

Hi coverturfLSH,

 

We are suffering exactly same issue Fabric compute capacity has exceeded its limits message error when importing from a WareHouse SQL Endpoint. Did you find any solution for the problem?

 

Many Thx

coverturfLSH's avatar
coverturfLSH
Icon for Resolver II rankResolver II
2 years ago

Hi alfBI,

Just to confirm from your end, are they able to query for SQL endpoint from other applications (Excel/SSMS/etc.) and it's strictly PowerBI Desktop that is failing?

It did eventually start working for my colleague but I can't pinpoint exactly what the resolution was. The last thing we did try before it started working was downloading Microsoft's ODBC Driver for SQL Server (https://learn.microsoft.com/en-us/sql/connect/odbc/download-odbc-driver-for-sql-server?view=sql-server-ver16) as we were going to try to use an ODBC connection instead of the built-in connector. From what I recall, we couldn't get this to work for some reason, but the built-in connector starting working after that. Maybe give that a try?