Forum Discussion

Helper I

2 years ago

Solved

How to select data sources for Power BI templates

We are a data provider and have developed a web application that allows advertisers to view and download advertising data reports on platforms such as Google Ads and Meta. We will sell this applicati...

Dataflow

Need Help

Tutorial Requests

Anonymous
2 years ago
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.

Anonymous

Not applicable

2 years ago

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

Helper I

2 years ago

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？