Hi Folks,
When I was working with my Power BI reports, I suddenly started encountering this error. I don’t have any more clue except this error message which I could see in my Power BI Desktop as below. Initially I thought there could be some problem connecting to my SQL end point of my Dataverse connection, but it isn’t.
The error message above clearly say that the Queries are blocked. I then quickly started reviewing the model of the Power BI Report to see if there were any issues like the Relationships etc. But I couldn’t find anything in my relationships. Since I was using SQL Connection to my Dataverse, I tried to increase the Command timeout in minutes (max value being 120 minutes) from Advanced options of my connection but still the same error.
Cause: Then I quickly noticed that in my model I have fetched the same table data both using Direct Query and Import mode. So, when I was refreshing, because of the relationships, the one imported is being dependent on the one with Direct Query.
Fix: After review, the unnecessary Direct Query table was removed and voila it fixed the issue.
If anyone is facing the same problem, I strongly recommend you review the Semantic Model of your Power BI Report.
Cheers,
PMDY
Discover more from ECELLORS CRM Blog
Subscribe to get the latest posts sent to your email.
ECELLORS CRM Blog 
Hello Pavan,
Thank you for your blog. I wanted to share that I’ve been experiencing the same error for a few weeks now, and I’ve run out of ideas for possible solutions. Suddenly, the semantic model in Power BI Service and Desktop stopped loading due to the error: ‘Microsoft SQL: The timeout period elapsed prior to completion of the operation or the server is not responding.’ All my tables are connected to Dataverse in import mode through Power Query in Power BI Desktop. Previously, the automatic load took about 10 minutes, but now it never finishes loading, and after 40 minutes I get the error. If you have any ideas you’d like to share, I’d really appreciate it.
Atte. Maria
LikeLike