Establish gateway connection to both data base and sharepoint

[Anonymous]

Hi All,

I would like to setup gateway connection to both data base and sharepoint for same dashboard and with schedule refresh with different timeframes. I have a report which has data related to both database and Sharepoint with relationship defined. When published, i am not able to see 2 gateway connections. hence, i am not able to schedule refresh seperately. Kindly let me know your inputs.

Thanks!

[v-piga-msft]

Hi @Anonymous,

Nornally, we only could set one schedule refresh under the same dataset.

For your scenario, if your SharePoint is online source, you could not set schedule refresh, it will refresh autumatically every day and you could set the schedule refresh for the data source of database.

Best Regards,

Cherry

[Anonymous]

Hi Cherry,

The gateway connection to the data base and sharepoint is possible. But , for schedule refresh, i am able to set refresh only once. Our organisation decided to set schedule database refresh every 24hrs. But for sharepoint, they need 15mins refresh. Currently both are refreshed every 24hrs. 

Thanks,

Keerthi