Forum Discussion
Analysis Services - Connect live vs. import help
If I connect to my Analysis services database "live", Power BI desktop works just fine. My tabular model/database is quite small and is only holding about 300 MB of data in-memory. However, if I...
Thank you for the reply. I had read that article. Something is definitely amiss in my situation. The entire set of in-memory data in SSAS is only 300 MB. How could importing that same set of data into my local Power BI desktop make my server RAM usage jump from 3 GB to almost 32 GB and throw an error? Keep in mind I hadn't createed any visualations in Power BI desktop. I was just trying to "load" the data after doing my initial connection to SSAS.
I thought I had perhaps defined my relationships incorrectly in my tabular model, but they're fine. For now my solution is just to connect Live (not sure why you'd import in-memory data anyway). The default is import, which I used when creating my initial connection.
