Creating Reports

When you create reports by using Power BI Desktop, you can create a connection to Dremio Software or you can connect through a Microsoft Power BI Data Source (.pbids) file that you downloaded from Dremio Software.

• If you want to create a connection, there are two different connectors that you can use: the Dremio Cloud connector and the Dremio Software connector.

  • If you want to enable single sign-on (SSO) on new reports that you publish to Power BI Service, use the Dremio Cloud connector. See Creating Reports by Connecting to Dremio Software with the Dremio Cloud Connector.

  • If you do not want to enable SSO on new reports that you publish to Power BI Service, use the Dremio Software connector. See Creating Reports by Connecting to Dremio with the Dremio Software Connector.

  note

  What is SSO?

  For example, suppose your Power BI Service username is user1 and that you publish report Widgets-2022-Q1. Another person, who has the Power BI Service name user2, runs your report.

  • Without SSO enabled:
    • If Power BI Service connects to Dremio Software directly: In Dremio, the username associated with the job that runs the query from your report is your username: user1.
    • If Power BI service connects to Dremio Software through a Power BI gateway: In Dremio, the username associated with the job that runs the query from your report is the username of the person who configured the gateway.
  • With SSO enabled: In Dremio, the username associated with the job that runs the query from your report is the username of the other person: user2.

  By enabling SSO, you make it easier for administrators in Dremio to know who exactly is running your reports.

• If you want to connect through a Microsoft Power BI Data Source (.pbids) file, see Creating Reports by Connecting to Dremio through .pbids Files.