Forum Discussion

Leann's avatar
Leann
Regular Visitor
9 years ago
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 ...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
9 years ago

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

Hogan's avatar
Hogan
Regular Visitor
4 years ago

I had this problem and when I viewed my cache, I noticed it was full. After clearing my cache the data loaded without further trouble. With your pbix navigate to File>Options and Settings>Options>Global>DataLoad>Data Cache Management Options>Clear Cache