cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jmcosi Frequent Visitor
Frequent Visitor

Not able to add scheduled refresh for on-premise gateway with multiple source files

I'm unable to schedule a refresh using the on-premise Gateway.  It appears that the issue is multiple file sources in my pbix.  

 

I'm attempting to use 4 Excel files within one pbix.  I have each source file set up under Data Source Settings.  It says the connections were successful.  But when I go to the Power BI Service, select the Dataset, and go to Gateway Connection, the Use Data Gateway option is grayed out.

 

I've already double checked that the file path is the same for both the Data Source Settings and within the Query Editor.

 

When I remove all the source files but one, then I am able to select the Gateway Connection. This makes me think the issue is related to having more than one Excel file as a source.   

 

I'm not able to consolidate to one Excel file, so I really need to figure out a solution here.  Thanks!

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Microsoft v-huizhn-msft
Microsoft

Re: Not able to add scheduled refresh for on-premise gateway with multiple source files

Hi @jmcosi,

Your resource data come from 4 Excel files which are located your local computer, right? If it is, you should create four resource dara in gateway. I try to reproduce your scenario and get expected result.

In my PowerBI desktop, I use two excel file in my local computer. After save, I publish it to Power Bi service. Create two date source, for the following screenshot, New data source1 add one excel, and New data source2 add another excel. 

2.PNG

3.png

In Power BI service, select the Dataset, and go to Gateway Connection, it works fine as follows.

1.PNG

Please check your operation and check if you create data source successfully.

Best Regards,
Angelia

View solution in original post

1 REPLY 1
Highlighted
Microsoft v-huizhn-msft
Microsoft

Re: Not able to add scheduled refresh for on-premise gateway with multiple source files

Hi @jmcosi,

Your resource data come from 4 Excel files which are located your local computer, right? If it is, you should create four resource dara in gateway. I try to reproduce your scenario and get expected result.

In my PowerBI desktop, I use two excel file in my local computer. After save, I publish it to Power Bi service. Create two date source, for the following screenshot, New data source1 add one excel, and New data source2 add another excel. 

2.PNG

3.png

In Power BI service, select the Dataset, and go to Gateway Connection, it works fine as follows.

1.PNG

Please check your operation and check if you create data source successfully.

Best Regards,
Angelia

View solution in original post

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors (Last 30 Days)