Forum Discussion

Leann's avatar
Leann
Regular Visitor
8 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
    8 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
8 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
5 years ago

Hello,

 

Tried the Solution above, still doeswn't work. Stuck at Creating Connection in Model.

This is happening after September2021 update of PowerBI Desktop.

I tried degrading to previous version of Power BI Desktop(August2021) Version. It is fixed now.

 

Regards,

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.