Skip to main content
Version: current [24.2.x]

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.

If Power BI Service connects to Dremio through Direct Query and you want to enable Single Sign-On for viewers of your report, you can follow either of these optional, additional steps if you want to enable SSO for viewers of your report.

If Power BI Service connects to Dremio through Power BI Gateway and you want to enable Single Sign-On for viewers of your report, you can follow either of these optional, additional steps.