Push data to Power BI directly using Azure Data Factory

[Mekaur]

Hi All,

I want to push data to power BI directly using Azure data factory. (No intermediate such as blob storage)

I have source as API which I will call in azure data factory to get the data and then push it to power BI directly.

Service principal is required to do so that is fine but which activity we can use in azure data factory to do so because firstly I have to authenticate the Source APIs in ADF and then authenticate power BI APIs using tenant ID,Service principal ID and Secret by getting OAuth token to call Power BI APIs.

My question is how to put together all of it.

There are example of refreshing the dataset but I need to take data from source and push it to Power BI.

Regards

mekaur

[amitchandak]

@Mekaur , Power Automate or Rest APIs

https://powerbi.microsoft.com/en-us/blog/refresh-your-power-bi-dataset-using-microsoft-flow/

https://medium.com/analytics-vidhya/schedule-refresh-power-bi-dataset-with-power-automate-b0af60f611...

Power BI API

https://docs.microsoft.com/en-us/rest/api/power-bi/datasets

[Greg_Deckler]

@Mekaur - Are you using the Power BI REST API or ?

[Mekaur]

Hi @Greg_Deckler ,

I am using API for source(Our Company specific) from where I want to pull the data and push it back to Power BI.

I am able to authenticate my company's API and ready to pull data so that I can push it back to Power BI.

I need steps how we can achieve it in Azure data factory.Pushing data to POwer BI directly.

Regards

mekaur