Forum Discussion
Importing data from Azure Analysis services
We are currently moving from OnPremise cube data to Azure analysis services, we currently have a number of reports set up using MDX to query the data but when i try use the MDX it seems to just crash and die and say i have hit a limit of 10gb. Of which i know there is not 10GB worth of data in there roughly 100mb?
Am i doing something wrong? should i not be using MDX
5 Replies
- is this when you publish or when you are importing the data?
Hi, Anonymous
Have you defined many-to-many relationships when any of the intermediate dimensions have 1 million or more rows in your mode?
Best Regards,
Community Support Team _ Eason- have you tried to use dax studio to see what code its generating from the mdx, might be useful.
also have you used the performance analyser?
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-performance-analyzer
v-easonf-msft to do this would i need to do it before i import the data at the model view in visual studio?
