Forum Discussion
stucking on creating connection in model
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
As of 1/30/24 I started experiencing this issue with none of the proposed solutions being successful. Are there any new updates on this root cause?
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!
Since a couple of weeks, I can't open some report because of memory issue ("Out Of Memory").
They probably have reduced their capacity. 😐
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.
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.
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*
