Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Helper IV
Helper IV

Power BI Direct Query Gateway Connection

My team have created and published enterprise level Power BI dataset in PBI service ( single version of truth reporting layer). This dataset is consumed by every department in the company to build their own Adhoc reporting and they can publish their content in their PBI workspace. All of our solution is in Azure cloud.

Due to the nature of reporting requirements consumer might need to bring in some data mapping which may reside on on premise server, e.g an excel file.This means to make change in the model , we need to switch to a direct query connection and we all know connection can’t be revert. The storage mode becomes Mixed.

If we try to open a report in a workspace, it pbi service prompts an error message below :

1. There is no gateway to access to enterprises level dataset
2. Verify the gateway connection configuration

As far as I know we don’t need to set up connection to the source that’s sits on cloud.

Super User
Super User

Hi @EricShahi 


As soon as you change it to mixed mode and add another dataset you would need the gateway to then connect to both of those datasets?

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Power BI Blog

Helper IV
Helper IV

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors