Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Everyone. I'm managing an On-Prem Power BI Server Version 1.6.7327.3007 (January 2020). I'm having this occuring issue with the service where this error pops up with templates that have just recently been modified on the server. This error is resolved when restarting the service it seems like. It's becoming an ongoing problem, since i have 200 dashboards on this with several users making updates and changes on the Dashboard Datasets daily. Looking for help in trying to figure out why this is happening but I think it could be queries getting cached in the powerbi/api or service that could be causing this. Trying to prevent this being the new normal. It's causing a lot of confusion and tickets to our dev group. Any advice would be greatly appreciated in troubleshooting this!
Hi Gilbert! I'm using internal Power BI Server, not the cloud version. Thanks!
Hi Gilbert. Correct. Users are updating the PBIX files. The nice Report Server actually, will not let you save a desktop version and yes, we make sure the users have the correct version installed on their machines through our IS department as well. In the past, we have had to migrate some templates into the newer versions. However, all of the versions we are using currently are matching also. I just created a brand new dashboard to test this theory using Power BI Optimized for Report Server (January 2020). Same exact problem. I saved it to a new file then went back today, added another dataset in there and a new visual, and ran into the same problem.
I did these two scenarios to fix the problem and encounterd these findings.
I've also had luck with restarting the service by resetting the service account credentials which stops and restarts the service. The problem suddenly went away on some of the reports that I hadn't tried to go fix yet and discovered this unintentionally (or this just happened to be a coincidence). I don't think it was coincedence because these issues had been happening on a new dashboard a user was trying to get up and we were struggling to find out why this issue was happening. Trying to isolate what is actually happening though has been really challenging. I've been looking through the logs on the actual server and I don't see anything that sticks out to the RequestId reference that it gives to the user with this message, so it's tough to troubleshoot.
Hey Gilbert. Yeah we've been manging this server for a year now and are understanding more about it all the time.
The odd thing is, the scheduled refresh hasn't failed, only the inability to display the visual to the user and it's definitely service related.
I don't know if the service runs seperately than the server. The service I'm referring to is the API that power bi uses to push the data to the front end of the user's browser. There could be lots of services running for Power BI Server itself. I am still trying to understand what this problem is stemming from. It hasn't been happening until recently after upgrading to the (January 2020) version but it didn't start right away either. There could be other factors. It's moving a lot of data now but our server doesn't seem to be struggling, but maybe the API is having a hard time keeping up too. Trying to see how to monitor that. Next step is contacting our rep for support. Just trying to see if anyone else is experience issues with managing the Power BI Server Internally regarding this issue.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.