Importing data from Azure Analysis services

[Anonymous]

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

[v-easonf-msft]

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

[Anonymous]

@v-easonf-msft to do this would i need to do it before i import the data at the model view in visual studio?

[Anonymous]

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]

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

[vanessafvg]

is this when you publish or when you are importing the data?