I've created a report which has connections to SQL on Prem and D365 (CRM) Odata.
When I published the report it is giving me an issue with the SQL Data Gateway. It wants the odata to go through it as well.
When I publish just Odata it correctly goes through the online source.
Has anyone else had this issue?
Go to Solution.
Hi @pcowman1 ,
You should select Allow user's cloud data sources to refresh through this gateway cluster > Apply.
Details refer to:
Thank you! Fixed now. Will be saving the page.
Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.
We spoke with Power BI Super User, Greg Deckler, about his charity work
Continue your learning in our online communities.