Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
Hi,
When I tried to use direct query to load data into Power BI desktop, I found that some columns' data type are considered as "Binary" (In Power Query Page), which is incorrect:
As you can see, "returned_order" should be "whole number" instead of "Binary"
And when I "close and apply", the "returned_order" column will be missing from my data field.
Note: Direct query won't allow me to change data type.
Any idea why this happened?
Hi @Alfred_Lee
There could be a few different causes but it sounds like it could be one of two issues:
Check the data format in your source to ensure it's the format you want (i.e. if source field if binary, see if you can have it changed to whole number). Alternatively, if the source is a whole number but Power BI is still reading it as binary, make sure your database drivers are up to date.
I hope one or the other helps with the above.
All the best!
Theo
If I have posted a response that resolves your question, please accept it as a solution to formally close the post.
Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!
Want to connect?www.linkedin.com/in/theoconias
Hi @TheoC ,
Thank you for replying. The data source is whole number for that field. And I didn't do any kind of transformation (I tried to change to whole number but it will break direct query, so I quit). It just automatically happened, that make me confused.
@Alfred_Lee - my apologies! I misunderstood.
Okay, given Power BI is making the changes without reasoning, have you checked the drivers to ensure that they're all up to date?
If I have posted a response that resolves your question, please accept it as a solution to formally close the post.
Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!
Want to connect?www.linkedin.com/in/theoconias
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
81 | |
75 | |
60 | |
37 | |
33 |
User | Count |
---|---|
102 | |
56 | |
52 | |
45 | |
40 |