Access Odata Feeds From Power Query. In the left pane select Other OData Feed and then select. We can load the available data in the power query editor and make changes to data.
Or use OData queries to connect and query the fields you need. To get to the OData feed URL from the dashboard navigate to the Developer Resources under Microsoft Dynamics CRM Settings Customizations. ODataFeedserviceUri as text optional headers as nullable record optional options as any as any About.
Im pulling multiple tables into the PowerBI dataset and the filter will be on just one of the tables.
Or use OData queries to connect and query the fields you need. Click on the multiple items checkbox. This URL should be the root of the OData service you. It makes use of a database which is also locally hosted and is created via code-first methods.