cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Cinkov
Frequent Visitor

PowerApps access in Mobile PowerBI (QR code scanner)

Hi!
I prepared a tool in PowerApp which allows you to scan QR codes and display content. The app work in PowerApp, but after implementation inside PowerBI report - the app is displaying but I don't cannot use a QR scanner (camera in phone). I got a warning that control of QR code scanner is not accepted in web viewer - try to use Power Apps for Mobile Phones.

 

If I go through this problem - also I am looking for a clue on how to filter PowerBI dashboard - using this scanned value.

 

 

1 ACCEPTED SOLUTION

Hey @Cinkov ,

 

1) Build a report URL that has query params that will used to filter the report (explained  here: https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-url-filters

2) Generate a QR code from this URL using any QR code generator.

3) Scan that QR code from Power BI Mobile app. The app will open the report and filter its data based on the query params you set.

 

Good luck,

Maya

View solution in original post

12 REPLIES 12
v-stephen-msft
Community Support
Community Support

Hi @Cinkov ,

 

Did you want to create a QR code for a report?

Please refer to

Create a QR code for a report to use in Power BI mobile apps - Power BI | Microsoft Learn

If you want to scan a QR code, refer to

Scan a Power BI QR code from your mobile device - Power BI | Microsoft Learn

 

 

 

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

@v-stephen-msft 

Thank you for your answer.

 

I know mentioned solution, but I am looking for possibilities to read QR codes in the same way that scanning barcodes (which are default scanner for PowerBi mobile). This is possible using PowerApp, but I don't know how to join it with PowerBi dashboard.

 

@lbendlin 

Thank you! I will check it.

Hey @lbendlin ,

 

Can you explain your scenario with more details please?

Are you looking to filter a report using QR code, with query params? we added support to filter report using query params in the QR code recently...

thanks, Maya

@mshenhav Maya, yes, that's what I am looking for. How can a user choice in the PowerApps visual impact the Power BI data model? Very curious!

Not sure about PowerApp, but if you have a QR generated from a Power BI report URL, that has query param (this QR can be generated by any QR generator that accepts valid URL) then scanning that QR from Power BI mobile app will load the report and will filter the data using the query params.

 

Maya

Could you explain it in more details?

I am not sure how to add this Query param to my project.

Hey @Cinkov ,

 

1) Build a report URL that has query params that will used to filter the report (explained  here: https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-url-filters

2) Generate a QR code from this URL using any QR code generator.

3) Scan that QR code from Power BI Mobile app. The app will open the report and filter its data based on the query params you set.

 

Good luck,

Maya

To sum up.

I used the way you described and it works pretty well! I had a problem with the names of tables/fields - so I changed them inside PowerBI to avoid special characters and spaces (I tried to use special string codes but I couldn't handle it). 

Also, I wasn't able to generate new QR codes (I had to work on existing ones, but they contain data that could be connected with my PowerBI report), so I used PowerApps to create QR code scanner which concatenate powerBI URL and formula for filter by value of QR code. It works very well, but I am curious, why PowerBi allows scanning only BarCodes and to QR codes needs big workaround.

It looks very encouraging. I've been stocked with filtering URL link. I checked it many times but I have no idea where is a mistake:

Cinkov_2-1666270284792.png

 

This is the end of URL Link (where I add filter). After paste, I got 'page can't be found' warning.

 

Also, How should I properly copy link - I took them from web link or using shared method (and they are different).

 

 

And second question - is it possible to filter not whole page but chosen visualization?

You need to encode all the spaces in your table name.

 

Filter a report using query string parameters in the URL - Power BI | Microsoft Learn

Don't want to hijack this thread, but I don't really care about the mobile app.  I am curious how to implement this on the desktop and in the service.

lbendlin
Super User
Super User

 

If I go through this problem - also I am looking for a clue on how to filter PowerBI dashboard - using this scanned value.

 

Power BI cannot get anything back from the PowerApps visual (at the moment).  So for now you need to record your PowerApps result in a third place (for example a SQL Server table) and then use that as a data source in Power BI (preferably in Direct Query mode, but it still won't be a seemless data round trip user experience).

 

If this is important to you please consider voting for an existing idea or raising a new one at https://ideas.powerbi.com

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

BizApps LATAM 2023

Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

Power Platform Bootcamp

Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.

Top Solution Authors