Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello,
How do you setup gateways for dynamic365 in powerbi for refreshing purpose? I have installed "On-premise data gateway" already. At the moment, the 'refresh' option is still greyed out. Checking the 'manage gateway', I try to add new data source but cannot see dynamics 365 as an option.
Thanks,
Ricky
Solved! Go to Solution.
@rickylee,
Do you take merge/append operation between D365 table and Excel table? If so, please install personal mode gateway and use it to refresh your dataset.
If you don't have merge/append queries, you can enable "Allow user's cloud data sources to refresh through this gateway cluster" option as described in this article and use on-premises gateway to refresh the dataset.
Regard,
Lydia
@rickylee,
You would need to add the Excel data source within gateway, otherwise, you are unable to use gateway to refresh your dataset.
Regards,
Lydia
@v-yuezhe-msft
I did not add excel data source within the gateway because the data does not need to be updated. So my concern is why the data in dynamic 365 online cannot be updated. As for the status, I am unsure which area you are referring to but I guess it is the following diagram:
Thanks,
Ricky
@rickylee,
You would need to add the Excel data source within gateway, otherwise, you are unable to use gateway to refresh your dataset.
Regards,
Lydia
Hi @v-yuezhe-msft,
I have tried that method in the past but it seems the gateway connection has problem. it does not give out a good error message though. There is something wrong but not sure what went wrong.
Thanks,
Ricky
@rickylee,
Have you added Excel data source within the gateway? Could you please post a screenshot about the data source status in gateway?
Regards,
Lydia
Hi @v-yuezhe-msft,
I connect to DYN365 online and data from personal spreadsheet. However, the data from personal spreadsheet does not need to be refreshed. So I can the powerBI only connect to DYN365 online.
My refresh tab in power bi website is greyed out. That is why I think I need to setup the gateway. If you connect to DYN365 online only, should I expect to use 'refresh' function instantly?
Thanks,
Ricky
@rickylee,
Do you take merge/append operation between D365 table and Excel table? If so, please install personal mode gateway and use it to refresh your dataset.
If you don't have merge/append queries, you can enable "Allow user's cloud data sources to refresh through this gateway cluster" option as described in this article and use on-premises gateway to refresh the dataset.
Regard,
Lydia
@rickylee,
Do you connect to Dynamics 365(online) or Dynamics 365(on-premises) in your Power BI report? Does your report only contain Dynamics 365 data source? If you connect to online dynamics 365 and want to set schedule refresh for your dataset in Power BI Service, no gateway is required.
If you connect to Dynamics 365(on-premises) , please use OData option when adding data source within gateway.
Regards,
Lydia
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
41 | |
30 | |
26 | |
21 | |
17 |