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

Reply
mrslyfox
Helper II
Helper II

don't have any gateway installed or configured

Hello,

 

After creation and publishing of the new report faced with trouble of scheduled data refresh configuration:

 

You don't have any gateway installed or configured for the data sources in this dataset. Please install a new personal gateway or configure the data source for an existing data gateway. 

 

Report has two data sources -> MSSQL and Excel file. (I never used Excel file as a source before)

 

 

2 REPLIES 2
v-ljerr-msft
Microsoft
Microsoft

Hi @mrslyfox,

 

Both data sources(MSSQL and Excel file) require a gateway(on-premises or personal) in order to refresh datasets on Power BI service. So you may need to install a new personal gateway or configure the data source for an existing data gateway(on-premises) in your scenario. For more details, you can refer to the following articles. Smiley Happy

 

On-premises data gateway

Manage your data source

 

Regards

Hello @v-ljerr-msft

 

For the MSSQL I have on-premisse  gw, but I do not want to refresh Excel data at PB service.

Exist a way how to disable it? 

Helpful resources

Announcements
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