Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / How to connect D365 F&...
Finance | Project Operations, Human Resources, ...
Suggested answer

How to connect D365 F&O with Power BI using Web API

(0) ShareShare
ReportReport
Posted on by Florian S. 100

Hi guys,

in a current project, we want to analyze some data stemming from D365 F&O. In order to do so, we have set up the Power BI Integration in D365 F&O, as indicated in : Configure PowerBI.com integration - Finance & Operations | Dynamics 365 | Microsoft Docs

This worked fine as we did get the needed configuration:


8308.pastedimage1615201979944v1.png

Now, I thought I can use these credentials also when logging into Power BI desktop using Web-API: When connecting to D365 (online) using Web-API method, this screen appears: 
7384.pastedimage1615202179729v2.png

However, I have no idea what key to insert here. The key provided by D365 F&O from the screen above does not work. I have look upon the I-net, but all tutorials do only show how to connect do D365 using an organization account. This is a way we do not want to use. 

So, can anybody tell me how to connect Power BI to D365 F&O using Web-API?

  • david.abax Profile Picture
    david.abax 40 on at
    RE: How to connect D365 F&O with Power BI using Web API

    I also would like to know how to connect to OData / F&O by using the Web API, without using a named user or organizational account.

    I still did not figure out what Power BI means and want from the field "Key", I tried every keys or IDs from Azure AD app registration and it throws the error message "A web API key can only be specified when a web API key name is provided."

  • Deepak Anmol Profile Picture
    Deepak Anmol 10 on at
    RE: How to connect D365 F&O with Power BI using Web API

    I would only like to use Web API Key of Dynamics, so that login should be non interactive.

    So, is there any way to generate the Web API Key of Dynamics, which I can further use in Power BI ?

  • Suggested answer
    WillWU Profile Picture
    WillWU 22,352 on at
    RE: How to connect D365 F&O with Power BI using Web API

    Hi Florian,

    Why you have to use web API to connect to D365FO?

    In your dialog, you can select Organizational account and click Sign in button.

    You'll access all the tables you're allowed to access according to your security rights and privileges, then you could pick the table you want in the list and load them to the Power BI and start working.

    pastedimage1615342678587v4.pngpastedimage1615342701779v5.png

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Congratulations 2024 Spotlight Honorees!

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December!

Congratulations to our December super stars! 🥳

Get Started Blogging in the Community

Hosted or syndicated blogging is available! ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,622 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,354 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans