I originally just uploaded the pbix file to the web portal. The file was built using the Power BI Desktop RS Jan 2022 version. Then I tried to open the pbix file in the RS Jan 2022 and published to our P1 capacity-backed workspace. The issue persists.
Then I opened the file in Power BI Desktop Oct 2022 for powerbi.com version. I saved the file and published it again. The issue persists.
Some of the data source connections are also used by other reports without an issue. The other connections were created just for this report.
The connections are consisted of SQL servers and file shares.
We have 2 windows 2016 VMs in a cluster to host the on-prem gateway. Version Aug 2022.