Need help using Dynamics 365 + Sharepoint + Power BI

Hi Anonymous 

First question is beyond my specialty.

As searched, you could integrate between Dynamics 365 and SharePoint, but i'm not sure if it supports automatical creation or schedule refresh from Dynamics 365 to Sharepoint.

To get better answer, you need to ask in the Sharepoint or Dynamics 365 forums.

Second question:

when you configure schedule refresh for a dataset in Power BI Service, it would refresh and get the lastest data from data source.

But in your scenario, the data source is a excel file in sharepoint or a sharepoint list, so the lastest data is these data instead of the data inside Dynamics 365.

If question 1 is supported, that means the excel file in sharepoint or a sharepoint list synchronizes with Dynamics 365, then data after refreshing in Power BI would be the lastest data from Dynamics 365.

Additionally, which Dynamics 365 entity do you need to connect to?

In Power BI Desktop, there are some connectors which support for Dynamics 365. 

there are some references how to intergration between Dynamic365 and Power BI

https://predica.pl/blog/dynamics-365-powerbi-data-analytics/

https://www.youtube.com/watch?v=Jtf2g15lG-o

Best Regards

Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.