D365FO with Azure Datalake Gen2, Schedule refresh option is not available

[Gokulg]

Hi Team,

After installing Azure Datalake Gen2 in D365FO, able to publish the tables to ADL but i could not able to see any refresh data option in D365FO. Please let me know how schedule refresh works in D365FO with ADL Gen2, kindly share me documents if available

Thanks,

Gokul

[V-lianl-msft]

Hi @Gokulg ,

Could you please try below steps which are clearly given in this article and check if that works for you.

https://www.purplefrogsystems.com/paul/2017/06/connecting-power-bi-to-azure-data-lake-store-across-t... 

And you had to whitelist the Azure IP's for the region in the ADLS.
https://www.microsoft.com/en-us/download/details.aspx?id=41653&751be11f-ede8-5a0c-058c-2ee190a24fa6=...

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Gokulg]

Hi @V-lianl-msft ,

Thanks for your sugesstions, Actually from Power BI services the scheduled refresh option works fine but from D365FO there is no refresh option available to refresh the data from F&O to ADL .

From F&O Entity store the refresh option is available(Every hr, day, week)  but from Publish to Datalake page there is no option to schedule refresh the data from F&O to ADL.

Can you please let me know if any option available for schedule refresh option in D365FO other than Entity store option. Also if any proper documentation to connect D365FO to ADL Gen2 and Power BI will be helpfull

Regards,

Gokul