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

mwhalen's avatar
mwhalen
Regular Visitor
2 years ago

I've been driving myself crazy for the last 3 days trying to figure this issue out. The only message I have gotten pertained to my model not being able to refresh due to memory, so I tried unselecting the boxes at data load, I've removed like 60% of the columns across all my tables, and still can't refresh, data load, or publish anything. I can't believe there hasn't been a post or solution from this week regarding this issue!

marlark's avatar
marlark
Frequent Visitor
2 years ago

I identified my issue. There was an Append with two JDE tables and an Excel based file. Someone saved the file with the max number of Columns an Excel Sheet can handle. This caused a cascade effect where the root cause of off my radar because the owner of the file thought they built adequate restrictions on the file. *looks at the new hire*