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 getting is "Unable to complete the action because your organization's Fabric compute capacity has exceeded its limits."

 

The error does not make sense for the following reasons:

  1. No one else in my organization receives the error when using PowerBI to query from the warehouse or lakehouse 
  2. The user IS able to query from the warehouse when using DBeaver (Database tool), Power Query in Excel, and access the warehouse directly from the web. 
  3. The user installed PowerBI from the Microsoft store like everyone else in my organization. The user has also tried uninstalling and reinstalling but no success. 
  4. The user is an administrator in the workspaces that house the warehouses.

Has anyone else encountered this issue or have suggestions on other things we can try? All of my research tends to point to the Fabric capcity being the issue but again, this is a problem for only a single user no one else in my organization has this error message.

 

Thank you,

Cameron

data warehouse
power bi

4 Replies

  • HimanshuS-msft's avatar
    HimanshuS-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    2 years ago

    Hello coverturfLSH 
    Thanks for using the Fabric community.

    The way throttling works for Fabric is that it only rejects the users requests when the quota is used for more then 60 mins . Please read the document here : https://learn.microsoft.com/en-us/fabric/enterprise/throttling

    In your case all others user are using the WS and only one use getting this user. Please double check if this user is in the same WS as others are ? 
    If you do not have red flags , please work with the Microsoft support team by creating a service request . Please do share the SR# here , so that we can also keep an eye on the same .
    Thanks 
    Himanshu 

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

      Hi Himanshu,

       

      I don't think it's a quota limit because he can run the same queries in Excel (so no permission problems) and I have no problems running them in my PowerBI. Here's the SR#2402260040010096.

       

      Thanks,

      Cameron

  • 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?