Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
Hi All,
Is there any issues with power bi service.
we are using Azure SQL Server as a data source and i have 70k rows of the data is coming from view.
If run the view in sql server its taking only 1-2 minutes of time. If run the same view using direct query in power bi desktop its taking 20-30 minutes to load&refrsh the visuals.
how ever iam able to refresh the data in desktop with 20 minutes of time.
After publishing the report in the services iam getting error like (exceed available resouces).
Can any one suggest how to reslove this issue.Now my reports are down in PRODUCTION.
Regards,
Bajee.
HI @bajee,
For refresh time, current I don't found any effective solution to cut down refresh time, maybe you can try to swithc to direct query mode.
>>After publishing the report in the services iam getting error like (exceed available resouces).
Maybe you can take a look at below link which told about similar issues.
If above not help, please share more detail informations to help us clarify your scenario.
Regards,
XiIaoxin Sheng