Power BI Service Update (June 2022)
Problem
Microsoft Power BI Service (June 2022 - Client version: 2206.1.11664-train) now contains the ability to directly connect to Dremio Software without a gateway. See the following actions required to connect new or already published reports.
Solution
| I have a report... | To turn off a gateway |
|---|---|
| Created using Power BI Desktop (June 2022 or later) and published to Power BI Service | 1. In Power BI Service, open the Data hub tab. Click the vertical ellipsis next to the dataset and select Settings. 2. Expand the Data source credentials section and click Edit credentials. 3. Select an authentication method. 4. Set the Privacy level setting for this data source. 5. Click Sign in. |
| Published using Power BI Desktop (June 2022) to Power BI Service and a gateway was used to display the report | 1. In Power BI Service, open the Data hub tab. Click the vertical ellipsis next to the dataset and select Settings. 2. Expand the Gateway connection section and toggle On-premises or VNet data gateway off. 3. Expand the Data source credentials section and click Edit credentials. 4. Select an authentication method. 5. Set the Privacy level setting for this data source. 6. Click Sign in. |
| Published using Power BI Desktop (May 2022 or earlier) to Power BI Service and a gateway was used to display the report | 1. In Power BI Desktop, open the original report and republish the report to Power BI Service (now using new connector). OR 1. In Power BI Desktop, open the original report and navigate to Transform data > Advanced Editor. 2. In the Advanced Editor dialog, update source to: Dremio.DatabasesV300(“[your server]”, “Enabled”, null, null, null) 3. Click Done to update and republish the report. |
If the connection is successful, the report will run.