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

ChristopheFromS's avatar
ChristopheFromS
New Member
2 years ago

Since a couple of weeks, I can't open some report because of memory issue ("Out Of Memory").

They probably have reduced their capacity. 😐

 

marlark's avatar
marlark
Frequent Visitor
2 years ago

Take a look at my reply to mwhalen. It may be basic unexpected scenario like mine. *again, looks at the new hire*

 

If you have not looked yet, PowerBI desktop has a memory cache. Your issue may be tied to that if you have not checked already. When I thought that was my issue I had >2GB of cache. As noted in the other reply, it didn't solve my issue when I cleared it.

  • mwhalen's avatar
    mwhalen
    Regular Visitor
    2 years ago

    Not sure what my issue was. It seems to be fine now, either Microsoft fixed something, or it really required me letting a refresh in the Desktop app run for like 8 hours, then hours for publishing. I don't think it has anything to do with Sharepoint or number of columns in Excel, since everything in my semantic model is coming from SQL.