Query SSAS get error when importing data

[GrahamR99]

Hello

I have a connection in Power BI to a SSAS database, but when it imports the data I get the following error message;

Unable to cast object of type 'System.Int32' to type 'System.String'.

What does this mean?

The query is for about 85,000 records, is the query to big?

Regards

GrahamR99

[v-yulgu-msft]

Hi @GrahamR99,

How did you get data from SSAS database? Did you execute customize DAX or DAX query when creating a data soure connection? If so, please check whether you used wrong query to convert int data to string.

Best regards,
Yuliana Gu

[GrahamR99]

Hello Yuliana Gu

The query I used was MDX.

Regards

GrahamR99

[v-yulgu-msft · Accepted solution]

Hi @GrahamR99,

Please execute the same MDX query in SSMS to check whether it can return correct records.

Regards,
Yuliana Gu

[GrahamR99]

Hello

It was a problem with my MDX, I have found the correct query and it now runs in Power BI.

Regards

GrahamR99