Push data to Power BI directly using Azure Data Factory

Question

Hi All,&nbsp;I want to push data to power BI directly using Azure data factory. (No intermediate such as blob storage)&nbsp;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.&nbsp;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.&nbsp;There are example of refreshing the dataset but I need to take data from source and push it to Power BI.&nbsp;Regardsmekaur

greg_deckler · Answer

Mekaur&nbsp;- Are you using the Power BI REST API or ?

amitchandak · Answer

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-b0af60f611f1
&nbsp;
Power BI API
https://docs.microsoft.com/en-us/rest/api/power-bi/datasets

mekaur · Answer

Hi&nbsp;Greg_Deckler&nbsp;,&nbsp;I am using API for source(Our Company specific) from where I want to pull the data and push it back to Power BI.&nbsp;I am able to authenticate my company's API and ready to pull data so that I can push it back to Power BI.&nbsp;I need steps how we can achieve it in Azure data factory.Pushing data to POwer BI directly.&nbsp;Regardsmekaur

Forum Discussion

Push data to Power BI directly using Azure Data Factory

3 Replies

Related content

ETL Data Factory

Data Factory adding extra \ in JSON data

Sending Outlook Email using Data Factory Pipeline

Provisioning Data Factory Fabric

Azure Data Factory, Data Factory, Power Query: What is what?