schedule refresh error

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

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,

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

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,

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

Regards,
Lydia

Hi

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

      Yes

Thanks,

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

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.

Anonymous,

You don't have to install gateway on the same machine with Oracle, just make sure that  you are able to access Oracle database from the machine that installing gateway. You can install Oracle clients in the gateway machine to test the connection.

Regards,
Lydia