Forum Discussion
Connecting to internal API in Live or Direct Query mode
Hi PBIAniket ,
In Power BI, the connectors Web Connector, OData Feed, and ODBC are usually in import mode by default and do not support direct queries or live connections.
However, you can try to accomplish this by doing the following:
1.Using parameterized queries:
In import mode, you can use a parameterized query to pass the values selected by the user in the Slicer/Filter, and then use those parameters in the API call. While this is not a live connection, it can be updated by refreshing the data.2.Configuring Gateways:
By setting up a gateway, you can refresh data in Power BI Service without public direct access to the internal API.Refer to below document:
Add or remove a gateway data source - Power BI | Microsoft Learn
Best Regards,Adamk Kong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi PBIAniket ,
In Power BI, the connectors Web Connector, OData Feed, and ODBC are usually in import mode by default and do not support direct queries or live connections.
However, you can try to accomplish this by doing the following:
1.Using parameterized queries:
In import mode, you can use a parameterized query to pass the values selected by the user in the Slicer/Filter, and then use those parameters in the API call. While this is not a live connection, it can be updated by refreshing the data.
2.Configuring Gateways:
By setting up a gateway, you can refresh data in Power BI Service without public direct access to the internal API.
Refer to below document:
Add or remove a gateway data source - Power BI | Microsoft Learn
Best Regards,
Adamk Kong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly