Dec 03, 2019 - Ataira
If you need to retrieve images from a binary field from SQL Server to load into Power BI there are a couple of steps you must complete before you can include the images in your report. Though the binary field is visible in query editor it can’t be viewed or used in the data or report views.The solution is to convert the binary field to Base64 image format stored in a varchar field as shown below:
Then once the column is added format the column as “Image URL”
Microsoft Power BI is a suite of business analytics tools that enable organizations to analyze data and share insights. Power BI can be used to monitor the business and get answers quickly with rich dashboards available on any device.
© 2015 - 2020 by Ataira Analytics Inc