Forum Discussion
Datasource error - unable to convert
Hello, Lydia!
Thank you for your quick answer. As the "Changed Type" steps were not available under APPLIED STEPS, the solution I managed to come to was to reach out to the database manager and have him change the necessary columns from "string" to "integer".
As he explained, it is bad business having any of the columns go to "string" format like this anyway, so we were able to fix it and got my import up and running.
It is weird though, that Power BI doesn't import the rest of the table and just leave these fields to errors. Really defeats the purpose since the problematic columns might not be necessary anyway.
Cheers
Anonymous,
Do you get the above error after importing data from your source into Power BI Desktop? If so, go to Query Editor of Power BI Desktop, check if there is a "Changed Type" under APPLIED STEPS. Delete this step if it exists.
In addition, if you don't want to reserve the Column1, you can write SQL statement to get required columns during the connection process.
Regards,
Lydia
Hello, Lydia!
Thank you for your quick answer. As the "Changed Type" steps were not available under APPLIED STEPS, the solution I managed to come to was to reach out to the database manager and have him change the necessary columns from "string" to "integer".
As he explained, it is bad business having any of the columns go to "string" format like this anyway, so we were able to fix it and got my import up and running.
It is weird though, that Power BI doesn't import the rest of the table and just leave these fields to errors. Really defeats the purpose since the problematic columns might not be necessary anyway.
Cheers