Skip to main content
Version: 24.3.x

Creating Reports by Connecting to Dremio through .pbids Files

You can quickly create a connection to a single dataset by downloading a Microsoft Power BI Data Source (.pbids) file from Dremio and opening it in Power BI Desktop. You can then create and publish a report that is based on that dataset.

Prerequisite

Ensure that the Microsoft Power BI Desktop option is enabled on the BI Applications page. To enable this option, ask a Dremio administrator to follow these steps:

  1. Click This is the Settings icon. in the left sidebar.
  2. Select BI Applications in the sidebar.
  3. Toggle the switch next to Enable Microsoft Power BI Desktop launch button.

After the organization administrator completes these steps, refresh your browser window if you are viewing the SQL Runner.

1. Downloading and Opening .pbids Files

To open a dataset in Power BI from within Dremio, you can use the PowerBI button in the top right-hand corner of a dataset view. Perform the following steps:

  1. On the Datasets page, hover the cursor over the name of the dataset.
  2. Click This is the Power BI button. in the dataset metadata card that appears.

A sample file with the complete dataset location in its filename and Microsoft Power BI Desktop Data Source as the file type, is downloaded. For example, Samples.samples.dremio.com.NYC-taxi-trips-iceberg.pbids.

  1. Click the file to open it in Power BI Desktop.
  2. Click Load.
  3. Save the file.

You can now browse and analyze the data in the dataset.

2. Publishing Reports

After you create a report that uses data in Dremio, you can publish the report to Power BI Service.

  1. Launch Power BI Desktop.
  2. Sign into Power BI Service, if you are not already signed in. To sign in, select File in the top-left corner of the screen and then select Sign in at the bottom-left corner of the menu that appears.
  3. Navigate to Files > Publish > Publish to Power BI.
  4. Select the destination. You may pick from a list of available workspaces to choose the desired one on which to publish. Select the workspace, and then click the Select button to publish.

If Power BI Service connects to Dremio through Power BI Gateway, follow these additional steps:

  1. Log into Power BI Service.
  2. Select Workspaces > Name of workspace.
  3. In the list, find your dataset for your report in the list, click the ellipsis button, and select Settings.
  4. In the settings for the dataset, expand Gateway connection.
  5. Recreate your data source by following these steps:
    1. Select the Maps to field.
    2. Select Manually add to gateway.
    3. In the New data source dialog, create a data source that matches the one that you previously used for your dataset. However, give the new data source a different name.
    4. In the Authentication method field, select OAuth2. Then, follow these steps:
      1. Click Edit credentials.
      2. Keep the authentication method OAuth2 selected.
      3. Keep the privacy level Private selected.
      4. Click Sign In. Follow the sign-in process until you return to this location.
    5. Click Create.
    6. Return to the settings for your dataset.
  6. Under Gateway connection, verify that the new data source is selected in the Maps to field.

Result

Your reported is published and ready for other Power BI users to view it.