Forum Discussion
Helper IPower BI Inheriting Data Types from Microstrategy causing errors
I am not sure about what caused this problem for you, but you can extract the Source data from the errors by adding a new column based on the next formula (put your column name instead of Column1).
try [Column1] otherwise (try [Column1])[Error][Detail]
Super User
If you are seeing errors in the column whilst setting up the import I'd be checking those data values in the source to see what the issue is.
If the data is alphanumeric PQ should recognize this and change the column to Any or Text.
What is the data causing the errors?
After loading, click on the word Error in PQ to see what the error message is (2nd image).
Regards
Phil
Helper IHey Phil. Not sure the "What data is causing the errors?" is trying to ask. Here is one example of the error, but most values are two letters followed by ~9 numbers.