Report is not loading View data in Import Mode

[Anonymous]

Hi Team,

                  I am trying to load a new view into the Data Model in Import Mode from same DB connection.

After Waiting for some time the process is throwing error.

We are able to query the view in the DB and also if i am limitting the no of rows to half in the View then the data is loading.

[Anonymous]

Hi  @Anonymous ,

Please ensure that your database connection settings are correct. If you’re using a connection string, make sure it’s formatted correctly.

If your data model has many calculated columns or complex Power Query transformations, it could be causing this issue. Try simplifying your data model and see if the issue persists.
You can try clearing the data load cache in Power BI. Go to File -> Options and Settings -> Options -> Data Load -> Clear Cache.
Some users have reported that running Power BI as an administrator resolved their issue.

Best regards.
Community Support Team_Caitlyn

[Anonymous]

I did everythinmg. Its still throwing the same error for the one new view that was created.