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...
v-easonf-msft
Community Support
Community SupportHi, 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
I get the error before i even load the data, so unable to get to the relationship part. The relationships are set up as a tabular model view. Are you suggesting its done at this level?
- vanessafvg
Community Champion
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
