Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
mikemowgli
New Member

Connect to Dynamics 365 (OData Feed) using Service Principal credentials

Whenever system-to-system communication is needed, it is a good practice to user a service account (or service principal). We have created a Service Principal with read permissions on Dynamics 365, and we'd like to use its credentials to refresh the Power BI service dataset. So far, we haven't found how to do so, since it seems only human credentials are allowed.

3 REPLIES 3
Hunain
New Member

Hi @mikemowgli 

Is your problem solved?

I am also looking for a solution where I need to use service principle to authenticate odata feed. 

mikemowgli
New Member

Hello,

From what I see, neither of the second nor third links have anything to do with using Service Principal credentials to connect to the OData Feed.

The first link refers to using basic authentication after creating a Dynamics 365 Business Central instance in a hosting center with NavUserPassword authentication.

We are not in this situation. We already have a Service Principal, created in Azure AD, that can successfully connect to the OData Feed of D365 and pull data in Azure Data Factory. What we want to do now, is using this same Service Principal to connect to D365 OData feed from Power BI service and refresh the dataset.

v-zhangti
Community Support
Community Support

Hi, @mikemowgli 

 

Please refer to the following links in the hopes of helping you.

Power BI and Odata (Dynamics 365 Business Central) - Microsoft Power BI Community

Solved: Dynamics 365 TDS endpoint credentials not working ... - Microsoft Power BI Community

How to Connect to Dynamics 365 Data from PowerBI Desktop | PowerObjects (hcltech.com)

 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors