Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
Hi @GrahamR99,
Please execute the same MDX query in SSMS to check whether it can return correct records.
Regards,
Yuliana Gu
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
Hello Yuliana Gu
The query I used was MDX.
Regards
GrahamR99
Hi @GrahamR99,
Please execute the same MDX query in SSMS to check whether it can return correct records.
Regards,
Yuliana Gu
Hello
It was a problem with my MDX, I have found the correct query and it now runs in Power BI.
Regards
GrahamR99
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |