sorry to hear you’re having trouble with your report not being very speedy in the service.
It’s a bit difficult to diagnose without seeing the model/measures etc and totally understand you cannot publish due to confidentiality.
Are you using a lot of DAX iterators?
Lots of calculated columns?
What are you data sources?
I’d definitely recommend @AntrikshSharma two courses on DAX Studio and Optimisation, links below, for helping you understand where you have issues in your report.
@DavieJoe what I find confusing is that I am happy with the performance in desktop. Why would service performance be so poor?
I am not using many iterators. Mainly calculate and simple dax however I do have a lot of visuals to render but like I said, they render fine in desktop
When you have a PBIX open in Power BI Desktop, the data set is already loaded into memory. I’m pretty sure that the Power BI Service does not keep all datasets in memory all the time.
@KimC honestly as crazy as it sounds, I’ve had this happen to me a few times. I even had the service say it was unable to load.
I did the famous IT solution which was turn my computer off. Then turn on. I have a habit of leaving my system in sleep mode overnight. Lazy on my part but I have a lot of windows opened.
That’s the other problem. If you have a lot of applications in windows running it bogs down the Cache and CPU performance.
@DavieJoe & @Paul.Gerber thank you for your feedback. I needed to fix my problem quickly, so I changed my one page into 3 pages and it solved the problem and looks much better.
AntrikshSharma courses are on my to do list but I need some time to slowly work through it. Thanks for your responses