cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PKoffler
Regular Visitor

Power BI Desktop integration with Dynamics 2016 On-Prem

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...

6 REPLIES 6
v-caliao-msft
Microsoft
Microsoft

@PKoffler,

 

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

image

 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

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

 

image

 

Thanks

 

Parv

Hi

 

Please can we have an update asap

 

Regards

 

Parv

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

 

Looks like no Power BI for our org.

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
Regular Visitor

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...

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors