In this article, we will walk you through how you can connect to your data in Relational, Big Data or SaaS data sources via OData generated using Progress Hybrid Data Pipeline from Power BI. As Hybrid Data Pipeline supports OAuth2 for OData, we will be showing you how you can use OAuth 2 with OData in Power BI.
- Power BI
- Visual Studio 2017
- Power Query SDK installed in your Visual Studio
- If your Power BI is already running, save your work and Restart Power BI for the extension to show up.
- In Power BI, click on Get Data -> All -> HDPAOuthConnect. Choose it and you should now see a form as shown below where it will ask you to sign in.
- Click on Sign in and you should now see a login page for DataDirect Hybrid Data Pipeline.
- Login with your credentials, and you should now see the below authorization screen. Click on Allow.
- You should now be back on Power BI Sign in form, you should now be signed in. Click on Connect to see your data.
We hope this tutorial helped you to access your data securely using OData generated by Progress Hybrid Data Pipeline from Power BI. You can use Hybrid Data Pipeline in a similar fashion to connect to Oracle, Postgres, MySQL, DB2 etc., and even if they are On-premise you would be able to access the data from Power BI. If you have any questions or issues, feel free to contact us.