Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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.
Hi @mikemowgli
Is your problem solved?
I am also looking for a solution where I need to use service principle to authenticate odata feed.
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.
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.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
34 | |
30 | |
18 | |
12 | |
8 |
User | Count |
---|---|
50 | |
35 | |
30 | |
14 | |
12 |