Forum Discussion
PowerBI Reads Text as INT
Thanks for these links. I found them, too. They both confirm my finding that Power BI does not let me convert field types as they are read. I have to go back into my original server and re-sort the data so that Power BI sees its proper type. Taking off the "auto detect type" flag didn't work, and I don't have access to tell Power BI to read 1,000 rows to identify type. So I'm stuck reworking the original data.
Thank you so much for taking all this time with me. I am trying to get Power BI to read that particular column as text. So the syntax that you suggest works until I click "close and apply", and then I get this error:
So, is there a way that I can tell Power BI to read a particular column as text instead of assuming that it's an integer?
Hi StatsChick ,
I found two cases similar to your problem, please check the solution in the following links. Hope they also can help you solve the problem.
Failed to save modifications to the server. Error returned: ' OLE DB or ODBC error:
Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: [DataSource.Error
If the above methods still can't solve your problem, please share with us your sample pbix file and screenshot of the original data source data (excluding sensitive information).
Best Regards
Thanks for these links. I found them, too. They both confirm my finding that Power BI does not let me convert field types as they are read. I have to go back into my original server and re-sort the data so that Power BI sees its proper type. Taking off the "auto detect type" flag didn't work, and I don't have access to tell Power BI to read 1,000 rows to identify type. So I'm stuck reworking the original data.