Setting up PowerBI to access your D365 instance.

PowerBI is the primary business intelligence tool for D365 so when you setup your instance of D365 you will have to go an configure the connection between the two. You can see a written set of notes on the help wiki here

https://ax.help.dynamics.com/en/wiki/configuring-powerbi-integration/

Here is a quick overview.

D365FO 1611 – Update3 (7.0.4307.16141)

It’s referenced in the wiki notes but you the website used in the video to setup the client id is

http://dev.powerbi.com/apps

Cheers

Lachlan

11 responses to “Setting up PowerBI to access your D365 instance.

  1. Thank you for this, i was struggling to make it work and you helped!

    however, i am confused how does the instance filter the dashboard objects according company? or everything should be done in power bi (filters and design) and just simple displayed in operations?

    Like

  2. Thank you for that post, it helps me really much.
    … But … when i click on my Budget workspace to “Get started Power BI” (i have already authorized power BI) i get the error message :

    “An error occurred getting the Power BI groups. Please contact your system administrator.”

    And i have really no idea what is the error 😦

    Maybe somebody have already an experience with this.
    Thanks you, Best Regards Patrick

    Like

    • Hey Patrick
      If you can access powerbi.com and see your content but not having luck with it from D365 try checking you settings again in system administration to make sure the app that is configured ok. You maybe prompted to authorized PowerBI often if you haven’t accessed the UI for a while. if you still have issues try raising a support case.
      Cheers
      Lachlan

      Like

  3. Pingback: Setting up and environment to try the PowerBI report models – Part 1 | OrganicAX·

  4. Pingback: Setting up an environment to try the PowerBI report models – Part 1 - Microsoft Dynamics AX Community·

  5. Thanks for your video. When trying to embedding reports (not tiles) in Dynamics 365 for F and O, sometimes it is not possible seeing the content. Any ideas?

    Like

      • Hi Lachlan,
        Thanks for your mail.
        When I click under options/ open tile catalog..
        I get this answer:

        This content isn’t available.
        Learn more about Power BI.

        If I click on “open power bi” then I can see the report. The fun thing is that if I try to open a report created with another environtment – but same tenant, then it would open the report (embedded).
        Have you or anyone following had this issue?
        Thanks in advance
        Martha

        Like

      • Hi Martha

        Can’t say I’ve seen the same message. The open tile catalog isn’t available in all workspaces. What workspace are you using? If the report/content one of the Microsoft pbix files?
        Cheers
        Lachlan

        Like

      • If, for just testing – we try retail financial operations.’
        Which will be:
        ?cmp=USMF&mi=RetailChannelOperationsWorkspace
        The embedded will work with data from an old setup.
        But not for reports made with data from the new updated setup.
        /Martha

        Like

Leave a comment