Forum Discussion
Binary Data Displaying in PowerBI Report
Hi,
Is there a possibility to display a word,PPT, or xlsx information stored in binary format in a database to be displayed in powerbi visual level.
Below is a example of how the data is stored in db Table:
IncidentId IncidentDesc. IncidentFile. IncidentFileType
10001. ABC. Binary Data jpeg
10001. xyz Binary Data docx
10002. ABCD Binary Data xlsx
10003 wxyz Binary Data pdf
In PBI Report we need to display the above data as such and the binary data column as a Hyperlink were when we click on that data the relevant file needs to be identified and it has to be opened accordingly.
Is this can be achieved in PBI Report level?
Highly appreciate any leads on this.
2 Replies
Think about what you are trying to achieve, and if Power BI is the right tool for that.
The hyperlink is a good idea. Keep the files on a sharepoint/onedrive, and list the links in Power BI.
That's actually something we are trying to explore and would like to do.
Bring in a specific binary and open it and show it, or transform the stored binary data.
I'll keep track of this.
