Forum Discussion
Power BI Gateway Issues
HI Team , I am using majorly 2 Data Sources 1. SQL server 2. CRM (Dataverse) I have a on premise gatway installed for the SQL server DS which is working fine . But i am getting a connecti...
Please don't. As soon as you merge on-prem and cloud data sources in Power Query bad things will happen
- you need to set your gateway to allow refresh of cloud data sources
- you need to add the cloud data source to the gateway
- you can never go back from that
So please don't.
i am merging two tables ( both of them from datverse )
also i have enabled refresh of cloud data sources
When i manually try to add the cloud data source to gateway it gets added and appears in the connections but it doesnt get mapped as in it doesnt appear in the box or in the drop down