Forum Discussion

Tangelo-tech's avatar
Tangelo-tech
Helper I
2 years ago
Solved

Power BI REST API

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?

After completing these tasks, how to use the Power BI REST API to achieve my goals?

  • lbendlin's avatar
    lbendlin
    2 years ago
    My Power BI reports are fed by multiple data sources. Some of these data sources are not accessible from the Azure cloud.

    Some of these data sources seem to require a local gateway.  You either need to add that to your setup, or refactor your solution such that none of your data sources require a gateway.

10 Replies