cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
CaFerguson Frequent Visitor
Frequent Visitor

Scheduling Refresh for data from OData Feed to CRM On-Premise in Service

I have been told that being able to connect to Dynamics CRM On-Premise (IFD) via OData Feed is not supported in the Power BI Service (correct me if I'm wrong).

 

You are able to get as far as authenticating the data credentials but the OAuth option is not currently available and as far as I know this is the only option that works in Desktop.

 

Has anyone had any experience with this issue and are there any work arounds available?

 

All I am wanting to do if publish a report which uses data from Dynamics CRM On-Premise (IFD) and be able to refresh it on a schedule. I do not want to have to publish it manually everytime the data updates.

3 REPLIES 3
Moderator v-yuezhe-msft
Moderator

Re: Scheduling Refresh for data from OData Feed to CRM On-Premise in Service

@CaFerguson,

As per this official article, scheduled refresh of reports isn’t supported with Dynamics CRM (on-premises) datasets that are published to the Power BI service. I am afraid that you would need to manually upload PBIX file to Power BI Service after you manually refresh data in Power BI Desktop.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
CaFerguson Frequent Visitor
Frequent Visitor

Re: Scheduling Refresh for data from OData Feed to CRM On-Premise in Service

Thanks for the response @v-yuezhe-msft.

 

I was aware of the article but was hoping someone might have found a workaround.

 

Any idea on whether support for this is in the pipeline?

I saw Dynamics Business Central now has an on-premise connector, surely D365 is coming soon. 

Moderator v-yuezhe-msft
Moderator

Re: Scheduling Refresh for data from OData Feed to CRM On-Premise in Service

@CaFerguson,

Unfortunately, there is no official information stating the pipeline.

Regards,
Lydia

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