Forum Discussion
Value for mixed data
Hi all,
In one of our column, we have mixed data with numbers and text, example: AH34839, and in the same column we have only rows with numbers, exemple: 41774230 so when we try to import this Excel file to PowerBi, it's give us an error for this column, because of those mixed rows.
Is there any solution to resole this issue, to be accepted without errors in PBI .. so when we try to change the value, there si no porposition for "text and numbers" to chose.
Thanks a lot to all of you.
I found how to make that it's working. Maybe it's the same thing like you wrote me, but I'm glad that it's working well for me.
In Advanced Editor, "{{"Master Customer Name (Inc)", type text}" I replace "text type" by "general", same option for data type that you can find in Excel, but not in PBI.
So, when I pressed save, it's give me an error code, but at this moment I press on remove "changed type", and this is what's changing my data type in ANY, what I need actualy, it's same as general in Excel. So, I tested it, and it's show me now in my table all informations, even in filter, when I press now "Load More" it's show me all what I need.
Thanks a lot Anonymous
12 Replies
Hi LuteceFalco
By creating a query, PBI Desktop creates a step called "changed value", in which Power BI tries to define the type of data you used, based on the first rows.
If the first rows are number, then type will be decimal or whole number.
So, if the next rows contains have text, the query will fail.
Turn off this step and define the data type yourself.
Hi Anonymous,
I already tried this, but when I go to filter, and press "load more" in filters, it's still give me this error "[DataFormat.Error] We couldn't convert to Number"
