Forum Discussion

PbQ1's avatar
PbQ1
Frequent Visitor
1 year ago
Solved

Change Source from Data source settings is hanging and doesn't show sources

Expected result would be to open up the view of datasources from the workspaces I have access to. Currently on 1 specific report (the others seem to work fine), it simply hangs with nothing appearin...
Need Help
rajendraongole1's avatar
rajendraongole1
Icon for Super User rankSuper User
1 year ago

Hi PbQ1 - Make sure that nothing has changed with the data source (such as credentials, database schema, or server availability).If there are changes, try updating the data source settings manually by going to File > Options and Settings > Data Source Settings and editing the data source connection.

Sometimes cached credentials or metadata might cause issues. Try clearing the Power BI Desktop cache:

  • Go to File > Options and Settings > Options.
  • Under Global settings, select Data Load and click Clear Cache.

If you're using Power Query to load data, check if there are any complex query dependencies that could be causing issues. You can inspect the query dependencies in Power Query Editor by selecting View > Query Dependencies.

Try breaking the report into smaller parts or optimizing the DAX calculations to reduce the processing time.

 

Hope the above suggestions helps you