PowerBI Service error: OData: Unable to read data from the transport connection:

Currently experiencing this issue now. We are upgrading our NAV2013 on prem to Business Central (Cloud) and for reporting, this has been a tedious experience using web service. The issue seems to be the communication to BC and the time it takes to retrieve the data before timing out or the error the author is receiving. The other issue is from Power BI where it takes ages to apply steps in Power Query. We created custom pages with filters to reduce rows, removed calculated columns from the pages, and reduced queries in power bi as well. We also tried Azure Synapse Link using virtual tables from BC to Dataverse but ASL doesn't support virtual tables. Not sure if Power BI Premium Capacity will help or not and that costs a lot of $. Anyone found a solution or workaround?