Forum Discussion
Helper IHow 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 application to multiple customers, and each customer can obtain their data reports by authorizing them to log in to the advertising platform through OAuth2.0. Each customer has their own data table containing their data stored on our server. Now, we want to use Power BI to provide some standard charts displayed based on customer data.
I created an automatic template application following the instructions in the Power BI documentation（Automated configuration of template application installation ）. They only need to select "Install" and authenticate their data source to obtain visual charts corresponding to their own data.
Now I am encountering a problem where I have configured the parameters and am prompted with Data source not supported, as shown in the screenshot.
What data source method should I choose to allow different customers to connect to their own dataset through parameters, similar to the screenshot below. Also, does this method require purchasing Power BI servers to store our data sources?
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.
8 Replies
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.
- 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
