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

orangeatom's avatar
orangeatom
Icon for Resolver I rankResolver I
4 years ago

hi bharath47 in August 2022, this issue is back, advise on solutions. Latest PowerBI client is downloaded as of August 4th, 2022.

  • bharath47's avatar
    bharath47
    Icon for Microsoft Employee rankMicrosoft Employee
    4 years ago

    orangeatom - Workaround could be to manually refresh the table one by one in Power BI Desktop "InsteadOf" RefreshAll. That helped me progress.

  • saintsitive's avatar
    saintsitive
    Regular Visitor
    4 years ago

    September 2022 still doesn't fix the issue for me, still stuck on creating connection in model for bi that import data from web 😞