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!
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!