Forum Discussion
Refreshing Power BI Dataset from Azure Data Factory with Cross-Tenant Configuration
Ideally leveraging a service account without MFA to generate OAUTh token is not a good security practice.
You can create an Azure function within the tenant in which the Power BI dataset is present, grant access to the Azure function in the workspace and write code within Az function to generate OAUTh token.
Then trigger the Azfunction via ADF and pass the OAUth toke into web activity for power bi dataset refresh etc
Please refer to the below link :
Note : Even if the Dataset is in another tenant as ADF, you can have the service principal created in the tenant within the Dataset and leverage it within ADF
Hello Nandan,
Thank you for your response! I understand that Service Principals are typically used for authentication, but unfortunately, I am unable to use a Service Principal in my scenario.
Since I cannot use a Service Principal, could you please provide guidance on how I can use a service account (or another approach) to trigger a Power BI dataset refresh when the dataset resides in a different tenant?
Ideally leveraging a service account without MFA to generate OAUTh token is not a good security practice.
You can create an Azure function within the tenant in which the Power BI dataset is present, grant access to the Azure function in the workspace and write code within Az function to generate OAUTh token.
Then trigger the Azfunction via ADF and pass the OAUth toke into web activity for power bi dataset refresh etc