Power Query Preview never completes

[PAPutzback2]

My data source is an Azure SQL database running on a managed instance. I have at least 100 reports that work fine. Today I opened an existing report and when I tried to refresh the table in Power Query, the refresh just hangs and never fails or moves past the navigation step. The crazy things is I can close Power Query (Close, not apply, or close and apply) and the report will evenutally get the schema of the table and let me build the report off of it. 

In this screnshot you can see it trying to refresh and it never completes.

If I go to the Report designer the table is shown and I can build off of it.

Data view and model view also pick up the schema from the view and will show the data.

The query takes about a minute to run and returns about 900 rows. So how is it possible for the designer to pull the schema and data and power query cannot? I have cleared caches and rebuilt the model from scratch and it still doesn't work. Luckily for this report I don't have to add additional steps in Power Query for this particular query.

[PAPutzback2 · Accepted solution]

I went through clearing caches and rebuilding the model\report from scratch. Then after enough Googling I found a post saying query folding can couse trouble. I change the source from using the view directly and instead changed it to a SQL query "Select * from VIEW" and that fixed the problem.
I appreciate the responses. Thank You.

[Daryl-Lynch-Bzy]

Hi @PAPutzback2 - can you please open Power BI Desktop without the model and then delete the cache from the Options panel.  Then close Power BI Desktop.  Then open the original file.

[PijushRoy]

Hi @PAPutzback2 

For checking purpose, turn off load existing table

Please try to create new table same schema and table and check new table is working on load.

If you have any question, please keep posted
If solve your requirement, please mark this answer as SOLUTION
If this comment helps you, please LIKE this comment/Kudos