Forum Discussion
Queries breaking
Thank you Nickgastaldi, I think I found the problem. One of the issues was that I am running 32bit Excel on my computer but the server had a 64bit Excel version installed. When changing the server version to 32bit the query started to run but froze at one point. When going one by one through the almost 50 different raw data files I noticed that with moving the files from my local computer to the server about a handful fell into 'protected view'. When resolving the 'protected view' it worked. Thank you again for your help!
Many Thanks Nickgastaldi, I am mainly using Excel tables pulled out of dedicated folders. The report is complex as I need to relate in total 27 different files (9 files with lookup tables, 6 raw data source files and 12 files for allowing appropriate slicing across the reports). What's most weird is that sometimes it works and other times not. When I am rebuilding a query that the error is indicating I am automatically running into the next. I've now cleared the cache and re-booted my PC (that is quite a powerful one) and will give it another trial. Many to Many relationships I am avoiding usually as I know that this can cause issues.
Hi schaema3,
This blog will be helpful for you.
In addition, if your data source is very large or the queries are complex will affect the performance of your report.
For reference about Power BI performance, you could have a good look at this document Power BI Performance Best Practices.
Best Regards,
Cherry
Thank you Nickgastaldi, I think I found the problem. One of the issues was that I am running 32bit Excel on my computer but the server had a 64bit Excel version installed. When changing the server version to 32bit the query started to run but froze at one point. When going one by one through the almost 50 different raw data files I noticed that with moving the files from my local computer to the server about a handful fell into 'protected view'. When resolving the 'protected view' it worked. Thank you again for your help!