Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

PBI connect to Dynamics 365 for Operations

How can I set up a connection from Power BI Desktop to a cloud Dynamics 365 for operations environment for custom reporting?
Need Help
Eric_Zhang's avatar
Eric_Zhang
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago
Anonymous wrote:

How can I set up a connection from Power BI Desktop to a cloud Dynamics 365 for operations environment for custom reporting?

Anonymous

I'm not familiar with Dynamicas 365, doesn't the connector in Power BI desktop work?

If "operation enviroment" is someting specific that can't be imported by the connector, do you have to call the Dynamics 365 API for it?

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi Eric,

 

Thanks for responding. The default connector works for Dynamics 365 (CRM), but returns a 500 server error for Dynamics 365 for Operations when I enter the API url.

 

As an alternative, if the option is available, I would like to be able to connect directly to the SQL database.