To retrieve binary values in Power BI, follow these steps:
Navigate to the "Power Query Editor" by clicking on "Transform Data" in the Home tab.
Click on the column containing the binary values.
Click on the "Data Type" button in the "Transform" tab.
Select "Binary" as the data type.
Click on "Close & Apply" to save the changes.
The binary values should now be visible in the appropriate column.
Note: Power BI treats binary values as text in the data model, so you may need to use the "Advanced Editor" to modify your query and perform any necessary conversions.
Please start posting anonymously - your entry will be published after you log in or create a new account. This space is reserved only for answers. If you would like to engage in a discussion, please instead post a comment under the question or an answer that you would like to discuss
Asked: 2022-09-08 11:00:00 +0000
Seen: 17 times
Last updated: May 27 '21
How to perform batch geocoding when longitude and latitude values are missing?
How can a new object with a specific type be created in Angular 2 using the domain model?
What is the method to eliminate NA from facet_wrap in ggplot2?
How can a text/varchar column be shortened when duplicate values are not permitted?
How are `all: unset` and `all: revert` dissimilar from each other?
How can I set values on a Map using more than one parameter from a nativeQuery?
What is the problem encountered when attempting to filter the column values of a data.frame?
How can an array be filtered using the values in another array?