Scan barcodes from the mobile app to get filtered data

Scan barcodes in the real world to go directly to filtered BI information in the Power BI mobile app.

Applies to:

iPhones iPads Android phones Android tablets

Say your organization has reports containing data that has been tagged as barcode data in Power BI Desktop. When you scan a product barcode using the Power BI mobile app's camera, you'll get a list of the reports that have barcode data. You can open the report you're looking for, automatically filtered to the information you need.

Screenshot of a product barcode scan, showing the scanner over the barcode of a colored beverage.

Note

On Android devices, barcode scanning requires that an up-to-data version of Google Play services be installed.

Here are examples of two scenarios where barcode scanning is useful:

  • Imagine you're checking inventory in a large supermarket and while you're out in the aisles you need to get information about particular products, such as how many the store has in stock, or what departments the items are stocked in. You can just open the Power BI scanner on your mobile device and scan an item's barcode. You'll get a list of reports that have barcode data. You choose the relevant report and the report opens, filtered to the relevant data.
  • Say the machines on a factory floor are identified with barcodes, and the telemetry from those machines is being processed and sent to Power BI. When engineers are out on the floor checking machine status, they can easily scan a machine's barcode and get to a KPI report about its performance and status.

Scan a barcode with the Power BI scanner

  1. On the navigation bar, tap More options (...) and then tap Scanner.

    Screenshot of the More options on the navigation pane, showing the scanner selection.

  2. If your camera is not enabled, you'll need to approve the Power BI app to use the camera. This is a one-time operation.

  3. Point the scanner at a barcode on the item you're interested in. You will see a list of reports that have barcode fields.

  4. Find the report you're looking for and tap to open it on your device, automatically filtered according to the barcode you scanned. If the report doesn't contain the barcode, you'll get the message "Couldn't filter report". In that case you can go back to the list and try another report.

    Note that the Barcode icon in the report's action bar is active, not greyed out. This indicates that the report is currently filtered by the barcode.

    Select the Clear Barcode icon if you want to clear the filter and return to the unfiltered report.

    Screenshot showing active barcode icon in the report's action bar, indicating that the barcode filter is active.

    Note

    If there is only one report with a barcode field, you won't get a list of reports, but rather the report will open directly, filtered according to the barcode you scanned. If the report doesn't contain the barcode you scanned, you will get the message "Couldn't filter report".

Filter by other barcodes while in a report

While looking at a report filtered by a barcode on your device, you might want to filter the same report by a different barcode.

On the report's action bar, tap the Barcode icon.

Screenshot showing barcode icon on Power BI report action bar.

A floating scanner opens with a small menu.

Screenshot showing floating barcode scanner.

  • Focus the scanner on the new item to change the filter of the report to a different barcode value.
  • Tap Clear barcode filter to go back to the unfiltered report.
  • Tap Filter by recent barcodes to change the report filter to one of the barcodes you've scanned within the current session.

Considerations and limitations

The Filters pane gives no indication of barcode filtering. To know whether a report is currently filtered by a barcode, look at the barcode icons on the report footer:

Icons Meaning
Indicates that the report is currently filtered by a barcode.
Indicates that the report is currently not filtered by a barcode.

The mobile apps support Barcode filtering for reports that have only one barcode column across all report data tables. If you scan a barcode for a report that has more than one barcode column, no filtering takes place.

Issues with scanning a barcode

Here are some issues you might encounter when you scan a barcode on an item.

  • You get a message Couldn't filter report - Looks like this barcode doesn't exist in the report data: This means that the value of the barcode you scanned doesn't appear in the data model of the report you chose to filter. This might be the case, for instance, if the product whose barcode you scanned isn't included in the report. You can scan a different product, choose a different report (if more than one report is available), or view the report unfiltered.
  • You get a message Looks like you don't have any reports that can be filtered by barcodes: This means you don't have any barcode-enabled reports. The barcode scanner can only filter reports that have a column marked as Barcode. Make sure you or the report owner has tagged a column as Barcode in Power BI Desktop. Learn more about tagging a barcode field in Power BI Desktop.
  • Filtering returns an empty state. This could mean that the barcode value you scanned exists in your model, but all or some of the visuals in your report don't contain this value. In this case, try looking at other report pages or edit your reports in Power BI Desktop to contain this value.
  • You get a message Can't scan the barcode. (Android users only): Verify that Google Play services is up to date.
  • Barcode scanning functionality is not supported for reports based on Datamarts or default Power BI semantic models in Microsoft Fabric.