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

March Update

Check it Out!

Click here to read more about the March 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.