Hi, I'm completely new to PowerBI, and I'd like to play around with the tool but I can't load the data the way I'd like (basically, I'm trying to load a measure with one or more dimensions).
The error I get is:
"DataSource.Error: AnalysisServices: Server: The operation has been cancelled because there is not enough memory available for the application. If using a 32-bit version of the product, consider upgrading to the 64-bit version or increasing the amount of memory available on the machine."
Note: The same selection works just fine when I browse the cube from SSMS.
How to reproduce the issue:
I downloaded PowerBI and AdventureWorksDW2014Multidimensional-SE.
So I selected Analysis Services Data Source and selected localhost (with import option).
Next, I selected 'Order Count' from 'Sales Order' group of measures and 'Geography' dimension.
The same occurs with all kinds of measure+dimensions combination. I have a 32-bit version of Office installed but even with a 64-bit version the issue is just delayed, right?
Shoud I use the tool in a different manner? With other BI tools I usually drag&drop measures/dimensions and model the dashboard looking at the tables/plots. Here it seems mandatory to write MDX/DAX queries to limit the amount of loaded data.