Skip to main content

    Power BI

    Needs Votes

    Dynamics 365 (online) support for Direct Query

    Vote (11) Share
    Ted Wildsmith's profile image

    Ted Wildsmith on 17 Aug 2018 19:44:11

    Support Direct Query using Dynamics 365 (online) as a data source.

    Comments (1)
    Ted Wildsmith's profile image Profile Picture

    on 10 Jun 2021 08:12:41

    RE: Dynamics 365 (online) support for Direct Query

    Currently you can connect to On-Premises Dynamics (IFD) through the OData connector on Power BI Desktop.

    However, in the Power BI Service there is no option for OAuth in Data Credentials.

    No other options appear to work (Anonymous, WIndows, Basic, Key)

    It would be fantastic if you could connect to On-Premise Dynamics through the OData Feed and then being able to authenticate it with OAuth credentials when configuring the personal gateway in Power BI Service.