Connect to database via REST API from Power BI

[Anonymous]

Hi,

I need to connect to a database via REST API from Power BI. Am not sure what are the steps that should be followed in order to connect to a custom API from Power BI ( API is written in python). Any guidance will be much appreciated.

Thanks,

Priyanga

[v-jianboli-msft · Accepted solution]

Hi @Anonymous ,

Power BI can connect to data by using existing connectors and generic data sources, like ODBC, OData, OLE DB, Web, CSV, XML, and JSON. Or, developers can enable new data sources with custom data extensions called custom connectors. Some custom connectors are certified and distributed by Microsoft as certified connectors.

To use non-certified custom connectors that you or a third party have developed, you must adjust the Power BI Desktop security settings to allow extensions to load without validation or warning. Because this code can handle credentials, including sending them over HTTP, and ignore privacy levels, you should only use this security setting if you absolutely trust your custom connectors.

For more details, please refer to:

Connector Extensibility in Power BI - Power BI | Microsoft Learn

Power BI REST API Connector — The Power User

GitHub - migueesc123/PowerBIRESTAPI: A Microsoft Power BI Data Connector or Power Query Connector for the Power BI REST API

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.