Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

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.

rubensneto

***scheduled update*** Issu connecting power BI x SQL automatically

Submitted by on ‎12-13-2021 09:34 AM

I can do this manually, the problem happen only when I let it release automatically.

How can I resolve this issue?

rubensneto_2-1639416030444.png

 

Status: Investigating

Hi,

According to my research, Power BI creates queries that are as efficient as possible. Under certain situations, however, the generated query may not be efficient enough to avoid refresh that would fail.

 

To solve this problem, I suggest you to create views of the SQL Server tables to be used in the report. The views can restrict the number of rows and columns considerably. Then you can use these views as the data sources for the report.

 

For more advice, you can also refer to this blog:

https://blog.pragmaticworks.com/power-bi-performance-tips-and-techniques


If you still have a problem and want to get a solution for this kind of data refresh problem as soon as possible, it will be better if you can open a support ticket to get direct help from the technical support team of Microsoft.

https://community.powerbi.com/t5/Community-Blog/How-to-create-a-support-ticket-in-Power-BI/ba-p/6830...

https://powerbi.microsoft.com/en-us/support/

 

Best Regards,

Community Support Team _Robert Qin

See more ideas labeled with:
1 Comment (1 New)
Comments
v-robertq-msft
Community Support
Community Support
‎12-13-2021 06:34 PM
Status changed to: Investigating

Hi,

According to my research, Power BI creates queries that are as efficient as possible. Under certain situations, however, the generated query may not be efficient enough to avoid refresh that would fail.

 

To solve this problem, I suggest you to create views of the SQL Server tables to be used in the report. The views can restrict the number of rows and columns considerably. Then you can use these views as the data sources for the report.

 

For more advice, you can also refer to this blog:

https://blog.pragmaticworks.com/power-bi-performance-tips-and-techniques


If you still have a problem and want to get a solution for this kind of data refresh problem as soon as possible, it will be better if you can open a support ticket to get direct help from the technical support team of Microsoft.

https://community.powerbi.com/t5/Community-Blog/How-to-create-a-support-ticket-in-Power-BI/ba-p/6830...

https://powerbi.microsoft.com/en-us/support/

 

Best Regards,

Community Support Team _Robert Qin

Idea Statuses