Forum Discussion
Solved
stucking on creating connection in model
Hi, I have a data model in power bi desktop, the tables are loaded from ssas server, and it refreshed data well yesterday. But today when I pulled in more data (400,000 rows to 17,986,280 rows) to ...
Leann,
Do you choose “Import” or “Connect Live” mode to connect to SSAS database in Power BI Desktop? I would recommend uncheck the following options in Power BI Desktop and then refresh your data model.If the above error still occurs, please try to re-connect to the SSAS database in Power BI Desktop, pull in columns and rows you need to build report.
Regards,
Lydia
What worked for me is:
- Manually refresh tables in the "Data" pane until I found which table was not able to create a connection and was stuck
- Right click, Refresh Data on each
- Delete that table from the model
- Add that table back by directly connecting to it (again) via "New Source" (and in my case "Dataflows")
- Refresh that table manually as a test (worked!)
- Refresh all tables at once (worked!)
NOTE: In my case, this was a small table (57 rows) from a Dataflows connection to the workspace, and I was able to view the data in PowerQuery preview.
What DID NOT work:
- Changing settings in the File or Global options related to Data Load
- Evaluations, memory
- Set parallel loading of tables to one, and unchecking import/update/autodetect for relationships
- Turning off time intelligence and background data loading
- Clearing the cache
- Deleting all relationships to the bad table
- Deleting the table and adding it back in by copy/paste of PowerQuery code in Advanced Editor into a blank query did not fix the problem
- Downgrading to a previous version