Forum Discussion
Helper IHow to select data sources for Power BI templates
Hi Tangelo-tech
The reason for the "Data source not supported" error may be that PowerBI cannot directly support custom OAuth 2.0 authentication for off-the-shelf web applications.
You can try the following:
- Instead of relying on OAuth2.0 for each customer in Power BI, you can set up an API gateway that acts as an intermediary between customer data and Power BI. The gateway can use a web application to handle OAuth2.0 authentication and expose simpler authentication methods supported by Power BI, such as API keys. Each customer has a unique API key that is used to grant access to its data. In Power BI, you can use the Web Connector to pull data from the API gateway.
- In a Power BI template, you can dynamically change the URL or query string of the web connector based on the customer's API key usage parameter. In this way, each customer's instance of a Power BI report can extract the specific data relevant to it.
Best Regards,
Yulia XuIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Tangelo-tech
The reason for the "Data source not supported" error may be that PowerBI cannot directly support custom OAuth 2.0 authentication for off-the-shelf web applications.
You can try the following:
- Instead of relying on OAuth2.0 for each customer in Power BI, you can set up an API gateway that acts as an intermediary between customer data and Power BI. The gateway can use a web application to handle OAuth2.0 authentication and expose simpler authentication methods supported by Power BI, such as API keys. Each customer has a unique API key that is used to grant access to its data. In Power BI, you can use the Web Connector to pull data from the API gateway.
- In a Power BI template, you can dynamically change the URL or query string of the web connector based on the customer's API key usage parameter. In this way, each customer's instance of a Power BI report can extract the specific data relevant to it.
Best Regards,
Yulia Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Tangelo-tech
Anonymous Thank you very much for your reply. I think that's exactly the solution I'm looking for. But I still have some questions about how to set up an API gateway and which APIs are used. Can you provide me with more documentation addresses? I found a document,Gateways - Get Datasource is this the API I need to use？
- Tangelo-tech
Anonymous I tried to follow the plan you suggested and connect to the webpage using Power BI Desktop, as shown in the screenshot below. When choosing between anonymous or web API connection, I tried to choose anonymous, but the result showed no data.
When I tried to connect using a web API, I was prompted to set it up first and unable to proceed to the next step.
What should I do?I hope you can reply to me as soon as possible. Thank you very much.
Hi Tangelo-tech
I would like to apologize for the belated reply.
Does any error message appear? If so, can you provide it?
Best Regards,
Yulia Xu- Tangelo-tech
Anonymous When I tried to connect using a web API,Error prompt: Web API key can only be specified when a Web API key name is provided.
Can you tell me where to set up the web API and how to use it? It would be great if there could be a document explaining it.
