Using Power BI with ODATA

Owned by Piotr Bojko
Last updated: Aug 31, 2020
2 min read

  1. Choose from menu Smart QL → Export data

     

  2. You will be presented a popup. Copy connection URL from the popup from ODATA section.

     

  3. Launch Power BI.

     

  4. Choose Get data → OData feed

     

  5. Fill the URL field with copied value from Jira and press OK.

    You will be presented with authorization window. Choose Basic Authentication and fill user and password with your Jira credentials.

  6. Power BI connect to Jira and load available tables. Choose those needed for your calculations and press OK.

     

  7. Power BI will load the data from Jira.

     

  8. Use new data from Jira in your Power BI as any other data.