Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
NIVA
Frequent Visitor

Visualize QR code

Is it somehow possible to display a QR code from the DataSet data?
 
I would like a list and a QR code for each entry next to it.
The employee filters the list and can then scan directly from the display using the barcode scanner.
2 REPLIES 2
OwenAuger
Super User
Super User

I would say the easiest method to generate the QR codes is using a free API, for example the one described here:

http://goqr.me/api/

 

In Power Query, you can either construct the appropriate URL for the API and store in your table, or use the URL to pull in the binary image data from the API and turn it into a Base 64 image URL (using the method described here).

 

Personally, I prefer Base 64 in this case because the image is stored as static text and doesn't rely on an internet connection when viewing the report.

 

Then you just need to ensure the Data Category for the column is set to Image URL and the image will display in a table or visual that supports images.

 

Here's an example pbix created:

Link to QR Code PBIX

image.png

 

 

Regards,

Owen

 

 

 


Owen Auger
Did I answer your question? Mark my post as a solution!
Blog
Twitter
LinkedIn

I think it's a good idea.
 
I have about 1000 entries and offline it would be even better to be independent of the API. Otherwise I would always have to synchronize 1000 entries with the API.

Is it possible to access.net libraries in Power BI?
I already used ZXing.Net in a software.
 
Here is a link to the project:
https://github.com/micjahn/ZXing.Net
 
Would be great if you could use that to generate the QR codes.

Otherwise, I'd try the way you described it.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors