Power BI Desktop integration with Dynamics 2016 On-Prem

[PKoffler]

Hello everyone!

I have been trying, without success, to connect our Dynamics CRM 2016 On-Prem to Power BI Desktop using the following

However, when I paste the Instance Web API into PowerBi, I get an error prompt preventing me from progressing.  It reads "Invalid Arguments: one or more of the input fields is in the incorrect format".

I have tried removing the extra */* from the address, pasted all available addresses listed in the Customizations/Developer Resources settings, and still haven't had success.  All returned the same error prompt.

What am I doing wrong here?  This seems like a simple process and I'm missing something...

[v-caliao-msft]

@PKoffler,

For Dynamics On-Prem data source, you need to use OData Feed when connecting to it.

 Please refer to the link below to see the details.

https://community.dynamics.com/crm/b/debajitcrm/archive/2016/03/12/in-depth-power-bi-and-dynamics-cr...

Regards,

Charlie Liao

[psingh01]

Hi

I tied the suggestion but got below is this due to Scenario 2 – On-Premise with IFD from https://community.dynamics.com/crm/b/debajitcrm/archive/2016/03/12/in-depth-power-bi-and-dynamics-cr...

Is there any way artound this

Thanks

Parv

[psingh01]

Hi

Please can we have an update asap

Regards

Parv

[PKoffler]

Our On-Prem deployment is IFD as well, and I receive an identical error.

Looks like no Power BI for our org.

[psingh01]

Hi

Our client tried your suggestion but got below

Is this due to Scenario 2 – On-Premise with IFD from link 

https://community.dynamics.com/crm/b/debajitcrm/archive/2016/03/12/in-depth-power-bi-and-dynamics-cr...

[PKoffler]

Hello everyone!

I have been trying, without success, to connect our Dynamics CRM 2016 On-Prem to Power BI Desktop using the following

However, when I paste the Instance Web API into PowerBi, I get an error prompt preventing me from progressing.  It reads "Invalid Arguments: one or more of the input fields is in the incorrect format".

I have tried removing the extra */* from the address, pasted all available addresses listed in the Customizations/Developer Resources settings, and still haven't had success.  All returned the same error prompt.

What am I doing wrong here?  This seems like a simple process and I'm missing something...