cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
brett_walton
Helper II
Helper II

Not allowing me to select use data gateway after dataset change

 

I had a service running and refreshing nightly . I made a dataset change and republished it now it will not refresh and although my on premise gateway is running the  "Use Data Gateway" option is grey and unselectable. I deleted the entire set and republished confirmed that my data sources are configured and connected but this Use Data Gateway option is not open to be selected. 

 

Any Ideas ? 

 

Thanks 

 

 

1 ACCEPTED SOLUTION

Thank you for your reply this is all great information. Late last night I found my issue.

 

One of my data sources is an on premise shared drive, the exact path mapping between my file location on the desktop application and the data source in the PBI service did'nt match as my PC drive mapping started above the root node and my the path of my data source on the BI service was the full path.

 

Example :   My location on the desktop was  \node2\node3\file.xls (because the mapped drive pointed directly to node 2).

                  The data source on the service side was defined \\Node1\node2\node3\file.xls

 

I change the path via edit data soruces on the desktop app, republished and was able to use the on premise gateway.

 

I am going to suggest that they present an error log or message when data sources from a dataset are not found as a datasources in PBI service.  

View solution in original post

2 REPLIES 2
v-yuezhe-msft
Microsoft
Microsoft

Hi @brett_walton,

Could you please describe more details about that what changes you made in your dataset?

The issue that the "Use Data Gateway" option is grey could be caused by that you combine multiple data sources in a dataset, but you don’t add each data source under the on-premises gateway. If that is the case, please ensure that you add each data source under the gateway and then check if the "Use Data Gateway" option is available.

In addition, please note that on-premises  gateway doesn’t work with online data sources currently, thus if you combine on-premises data source and online data source in a dataset, you are not able to use on-premises gateway to schedule refresh for the dataset. In this scenario, you can use the personal gateway to schedule refresh for your dataset.


Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thank you for your reply this is all great information. Late last night I found my issue.

 

One of my data sources is an on premise shared drive, the exact path mapping between my file location on the desktop application and the data source in the PBI service did'nt match as my PC drive mapping started above the root node and my the path of my data source on the BI service was the full path.

 

Example :   My location on the desktop was  \node2\node3\file.xls (because the mapped drive pointed directly to node 2).

                  The data source on the service side was defined \\Node1\node2\node3\file.xls

 

I change the path via edit data soruces on the desktop app, republished and was able to use the on premise gateway.

 

I am going to suggest that they present an error log or message when data sources from a dataset are not found as a datasources in PBI service.  

Helpful resources

Announcements
August 1 episode 9_no_dates 768x460.jpg

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power BI Dev Camp Session 24 without aka link and time 768x460.jpg

Ted's Dev Camp - July 28, 2022

Watch Session 24 of Ted's Dev Camp along with past sessions!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Top Solution Authors