schedule refresh error

[Anonymous]

Hi 

   I need help for schedule refresh. My issue is first time use On primies Data gate that time I connected with sql server and set schedule refresh . But now my requirment with oracle so I need to new data gate way create with oracle connection but my issue is when i set schedule refresh that time my dataset conncet with old gata gateway connection so I how can I change datagate way coonect particular dataset .can u please help me to resolve this error?

Thanks.

[Anonymous]

Hi 

    I need to help for resolve this error.I was created report in Power BI desktop and then publish report in power BI service and I need to set schedule refresh but I am still getting error below image.

I install gateway in my system.why getting this error? can u please help me.

Thanks, 

[Anonymous]

@Anonymous,

Do you combine SQL data source and Oracle data source in a single dataset? If that is the case, except adding SQL Server data source within gateway, you also need add Oracle data source within the configured gateway, see https://docs.microsoft.com/en-us/power-bi/service-gateway-onprem-manage-oracle.

Then you will be able to choose gateway for your dataset and set schedule refresh for your dataset.

Regards,
Lydia

[Anonymous]

Hi Lydia,

     Do you combine SQL data source and Oracle data source in a single dataset? No

both are single dataset.their is no selection option in gate way which dataset use for gateway.

Thanks,

[Anonymous]

@Anonymous,

Have you added the Oracle data source within your gateway? 

Please post the data source setting(File->Options and settings->data source setting ) in Power BI Desktop and share a screenshot about the data source you added within your gateway. Do mask sensitive data before you upload screenshots.


Regards,
Lydia

[Anonymous]

Hi

          Have you added the Oracle data source within your gateway?  Yes 

I have add the oracle data source with gate way in power bi service Data gateway manage with all Credentials. but when set schedule refresh that time i getting above massage image. I still facing error . I need to help to reslove this error . Beacase I need to set schedule refresh.

Below Image PowerBi Service Data gate connection.

Below Image Power Bi Desktop Oracle Connection.and sorry I not able to give datasource access beacase their are confidential data.

Thanks,

[Anonymous]

@Anonymous,

Do you use same server name in Desktop and gateway for the Oracle data source?

Regards,
Lydia

[Anonymous]

Hi

      Do you use same server name in Desktop and gateway for the Oracle data source?

      Yes

Thanks,

[Anonymous]

@Anonymous,

I am unable to reproduce this issue. In my scenario, I use IP address as server name in both desktop and gateway, I can set schedule refresh for this dataset.

What version of Power BI Desktop and what version of gateway do you use? Do you use same data source credential in desktop and gateway for the data source?

Regards,
Lydia

[Anonymous]

Hi 

   I am also use IP address as server name in both desktop and gateway. I have question for this issue my oracle install in my company server so DATA GATE WAY is need to install on server?

Thanks.