Forum Discussion
Value for mixed data
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
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"
could you please paste your code and a pic of the error?
This is the first time for me, so I hope that I give you what you need as information.
= Table.TransformColumnTypes(#"Reordered Columns",{{"Master Customer Number (Inc)", type text}})
It's refuse to load the rows with mixed data inside.
Can you please send me the query code?
Click on "Advanced Editor" and copy & paste the code.