Forum Discussion

NCPowerBI's avatar
NCPowerBI
Helper I
2 years ago
Solved

Queries Won't Refresh

Hi all,   For some reason my queries won't refresh in Power BI Desktop. When I click refresh, it does nothing and no windows pop up showing an error. I tried restarting my computer and clearing the...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi NCPowerBI 


Here are some aspects that you can check:

  1. Check for Query Dependencies: Ensure that none of your queries are set to disable load. Queries set as such won't refresh as they are not loaded into Power BI Desktop. You can check this by going to the Power Query Editor, right-clicking on your query, and ensuring that "Enable load" is checked. For more details, please refer to the documentation on Managing query refresh - Power BI | Microsoft Learn

  2. Query Folding: If your data source supports query folding, ensure that your transformations in Power Query are not breaking this capability. Breaking query folding can significantly slow down or prevent refreshes. For more information on query folding and how to ensure it's not being broken, please see Query folding guidance in Power BI Desktop - Power BI | Microsoft Learn

  3. Data Type Mismatch: A common issue that prevents queries from refreshing is a mismatch in data types, especially when using incremental refresh policies. Ensure that the data types for your RangeStart and RangeEnd parameters match the data types in your data source. For more on troubleshooting incremental refresh, visit Troubleshoot incremental refresh and real-time data - Power BI | Microsoft Learn

 

 

 

Best Regards,

Jayleny

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.