Skip to main content
Version: 24.3.x

Publishing Reports Based on Datasets Derived from Dataflows

After you create a report that uses data in Dremio Software, 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.

  5. Log into Power BI Service.

  6. Go to the workspace to which you published the report.

  7. In the list of the contents of the workspace, hover your cursor over the entry for the dataset on which the report is based.

  8. Click the ellipsis to the right of the name of the dataset, and click Settings.

  9. If your aim is for your report to connect directly to Dremio, follow these steps to provide your credentials for authenticating to Dremio:

    1. In the settings for the dataset, expand the Data source credentials section.

    2. Click Edit credentials.

    3. Select the account that you want to use for authentication.

    4. Click Sign In.

  10. If your aim is for your report to use a Power BI gateway to connect to Dremio, follow these steps to map your dataset to a data source:

    1. In the settings for the dataset, expand the Gateway connection section.

    2. Toggle to On the switch Use an On-premises or VNet data gateway.

    3. On the right end of the entry for the gateway that you want to use, click the arrow. The tooltip on this arrow is View Datasources.

    4. Click Manually add to gateway.

    5. In the New data source dialog, name the new data source.

    6. In the Data source type field, leave the value as Dataflows.

      note

      In the Authentication method field, OAuth2 should be the only choice.

    7. Below the Authentication method field, click Edit credentials and sign in again to Power BI.

    8. Click Create.

    9. Return to the settings for your dataset.

    10. Under Gateway connection, toggle to On the switch Use an On-premises or VNet data gateway.

    11. Select the gateway for which you created the new data source.

    12. In the Maps to field, select the name of the new data source.

    13. Click Apply.