Power BI REST API

[Tangelo-tech]

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]

Do your data sources include Python or R scripts?

[Tangelo-tech]

not included

[lbendlin]

Can you show a sanitized list of the report data sources?

[Tangelo-tech]

As shown in the screenshot above, this is an advertising data report from one of our clients on the Google Ads platform. Now I hope to use an API key to search for this customer's corresponding data table in our database. How to achieve it? Our database is MySQL.

[lbendlin]

There must be another data source, one that requires a local gateway.

[Tangelo-tech]

Sorry, I don't know what to do. Can you describe the steps in more detail? For example, should I choose to connect to our web page and retrieve data from it? How to set up a gateway to identify each unique user and apply it to the Power BI template application?

[lbendlin]

Please validate or correct my assumptions

- You are using Power BI Embedded, App owns Data

- You are handling all user authentication and then passing that through to Power BI

- Your Power BI reports are fed by multiple data sources. Some of these data sources are not accessible from the Azure cloud.

[Tangelo-tech]

Hi，lbendlin

Regarding the first point, I am not sure if it is using Power BI Embedded and App owns Data.

Let me first introduce the usage process of my users (who do not belong to our organization or my company, but belong to different enterprise users).

Firstly, they need to log in to the Power BI service and then obtain and install my template application in AppSource.When connecting to their own data, I need to use an API KEY to identify this unique user and find their data, and then push the data to Power BI for him to use.I think you are right about the second and third points.

I am handling all user authentication and then passing that through to Power BI

My Power BI reports are fed by multiple data sources. Some of these data sources are not accessible from the Azure cloud.

[lbendlin · Accepted solution]

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.

[Tangelo-tech]

Thanks for providing the solution.Do you know how to set up an API gateway that acts as an intermediary between customer data and Power BI,such as API key.If you know, I hope you can provide me with more detailed steps. Thank you very much.