Forum Discussion

edwardrmiles's avatar
edwardrmiles
Icon for Helper III rankHelper III
9 years ago

Using the on-premise gateway with Dynamics CRM and on-prem SQL server

I'm trying to use the on-premise gateway for a model that has an on-premise SQL server and Dynamics 365 (online) data sources.   I have successfully installed both the personal and on-premise gatew...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
9 years ago

In theory this should work, I have built a bunch of models that mix on-prem and cloud data sources. Not sure of what you are seeing specifically though. Unless I am totally losing it, but I'm pretty certain that I have built CRM Online dashboards that mash-up on-premises data but I will have to go back and check. I do know that I was having some issues with refreshing my CRM Online dashboard due to OAuth2 issues, that's in another thread somewhere.

ranjithpv's avatar
ranjithpv
New Member
9 years ago

Hi,

I have the same issue. My PBI Desktop dataset uses 2 on premises SQL server databases and one Online Dynamic365 CRM.

Is there any method to get it refreshed using a data gateway schedules to the published powerbi online datasets.

 

Thanks & Regards

Ranjith.PV ([email protected])