Power BI Report Builder not responding loading query designer

Hi jafp ,

It seems that you're experiencing issues with Power BI Report Builder freezing when attempting to load the query designer. This could be due to various reasons, including compatibility issues, large datasets, or connection problems with the Power BI semantic model. Here's how you can troubleshoot and resolve the issue:

Try below steps to resolve:

1. Check Power BI Dataset Permissions

• Ensure your credentials are still valid for the Power BI semantic model.
• Open Power BI Desktop and verify that you can connect to the dataset without issues.

2. Verify Dataset Size and Complexity

• If the dataset is large or complex, the query designer might struggle to load it.
• Test the connection with a smaller or simpler dataset to see if the issue persists.

3. Use DirectQuery Mode (If Possible)

• If the dataset is set to Import mode, it may take longer to load. Try using DirectQuery mode in your dataset for a more responsive experience.

4. Clear Cache

• Power BI Report Builder caches metadata and queries, which can cause issues if the cache becomes corrupted.
  • Navigate to the following folder on your system:

    %AppData%\Local\Microsoft\Power BI Report Builder\

  • Delete the cache files and restart Report Builder.

5. Reinstall Power BI Report Builder

• Fully uninstall the current version, then reinstall the latest version from the Microsoft Download Center.

6. Test Query Designer in Other Reports

• Open another paginated report connected to the same Power BI semantic model. If the issue occurs with all reports, the problem may lie with the semantic model itself.

7. Update the Power BI Semantic Model

• If the semantic model recently underwent changes, ensure it is published correctly and no errors exist in the dataset.

8. Check System Resources

• Ensure your system has sufficient RAM and CPU resources, as Report Builder can freeze if your machine is under heavy load.

9. Collect Logs for Further Debugging

• Enable tracing to capture logs for troubleshooting:
  • Go to Options > Diagnostics in Report Builder.
  • Enable logging and reproduce the issue to capture detailed logs.
  • Review the logs for any specific error messages or bottlenecks.

Please mark this as solution if it helps. Appreciate Kudos.