Retrieving Images via an API call

[rsbin]

Good Morning,

I am dealing with the following scenario:

Am dealing with a database containing transaction details and image(s) for each transaction.

The database is approx. 40,000 records and growing daily.  Images are stored in a Wasabi Cloud server as a binary, so I don't have an image URL available to me to import. Even if I did, I don't think I would want to import such a large dataset.

The ask is that when a User selects a specific transaction (i.e. using something like the drill through functionality), they should be able to view the relevant image.

I am told that I need to use a POST API request to get the image as binary data.  Something like this:

"sessionid": "NS-c81bd8c3-fe04-11ec-8f5d-005056a2027d",
       "outputtype": "Json",
       "filePath": "\\172.30.250.43\ExpanDrive - Wasabi\remprex-xxx-freight\prod\North Dallas\TransactionImages\00cb579c-ee5f-11ec-b833-0050560e01ad\Rear Door Inspection 1.png"

But I am lost as to how to retrieve the image file that I am supposed to get.

We tried using the Python Script visual, but without success.

My Manager does not think Power BI is capable of handling this, so reaching out to one of experts to see if there are any other ideas out there.

Any thoughts, suggestions or comments would be very much appreciated!

Edit:   Would creating a flow using the Power Automate visual be a possibility?  Would love to hear from anyone with Power Automate experience.

Best Regards,

[v-jingzhang]

Hi @rsbin 

The Binary data type is not currently supported outside of the Power Query Editor. Inside the Power Query Editor you can use it when loading binary files if you convert it to other data types before loading it to the Power BI model. It exists in the Data View and Report View menus for legacy reasons but if you try to load binary columns to the Power BI model you may run into errors. 

As a result, it doesn't support to display images from binary files. You can try the method in this blog to see if you can convert the binary files to image URLs.

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.