Skip to main content

Publishing Reports

After you create a report that uses data in Dremio Cloud, 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 the dataset with which you created your report uses a Power BI gateway to connect to Dremio Cloud, follow these steps to map your dataset to a data source:

  1. Log into Power BI Service.

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

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

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

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

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

  7. 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.

  8. Click Manually add to gateway.

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

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

    note

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

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

  12. Click Create.

  13. Return to the settings for your dataset.

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

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

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

  17. Click Apply.

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

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