Power BI reporting on Dynamics CRM Online RRS feed

  • Question

  • I'm using Power BI to create reports on Dynamics CRM Online. In Power Query I connect to an OData Feed and use my Office 365 organizational account as login credentials. Then I add the Power Query data sets to the data model in Power Pivot and create some reports in Power View. After that I publish the workbook to Power BI in Office 365.

    To setup scheduled data refresh for the reports I configure a Data Management Gateway and create a Data Source for my Power Query data sets. This Data Source is connecting to the OData Feed url provided by Dynamics CRM Online. To configure the Data Source I have to provide login credentials to the OData Feed, but the available authentication types are Anonymous, Windows, Basic, Key (Data Market). It looks like these authentication types are not compatible with the Dynamics CRM Online OData Feed (Office 365 authentication type or Live ID authentication type?)

    Is the scenario I describe above allready supported by Power BI and what should I do to get it working?

    Friday, October 24, 2014 8:39 AM

All replies

  • Same issue here. There is no "organizational account" option that can be selected to match Power Query.
    Thursday, November 20, 2014 6:32 PM