Using OData Queries in Power BI

Chetta Busayarat

• 3 min read
Share
Using OData Queries in Power BI



Dynamics 365 provides an OData feed for data retrieval via a REST API web service; simply append `/data` to the URL.

  1. Example to feed data user your web service URL/data

  1. Goto power BI (https://app.powerbi.com/) to connect to the data.

  1. Goto "Create" > "Get Data".


4. Choose data source > New sources > "View more".


5. Choose "Other".

  1. Choose "OData".

  1. Copy URL on step 1 and past on "URL text box".
    Connection: "Create new connection"
    Authentication kind: "Organizational account"

    and click "Sing in" button.

  1. When click sign in will show account to select.

  1. After Singed botton will change from "Sing in" to "Switch account". Then click "Next".

  1. It will show "Power Query".

  1. Choose data (Example: custinvoicejourbi)

  1. Click "Transform data".

  1. Click "Create a report".

  1. Name the "Semantic model name" and click "Create".

  1. Creating.

  1. Design report page.

  1. Select "Vusualization" to show.

  1. Select "Data" to show.

  1. Add more view by click on blank space.

  1. And slect more "Visualizations"

  1. Select "Data".

  1. When finish click "Save this report".

  1. Enter a name of your report and click "Save".

  1. Now report ready to use.

  1. Use "Pin to a dashboard".

  1. Pin live.

  1. Or "File" > "Embed report" > "Publish to web (public)".