Automate from Azure AAD to Power bi

[prakash11440278]

Hi All,

I am importing Azure Active directory log excel sheet manually from Azure to power bi. Is there any method we can automate the process from Azure AAD to powerbi?

Regards,

Prakash.

[v-huizhn-msft · Accepted solution]

Hi @prakash11440278,

Azure Active directory log excel sheet is located your local computer or somewhere else? I assume it's stored in local computer. You can get data in Power BI service, create report using the excel. Install a data gateway, add the excel path in gateway, configure a scheduled refresh. Then the data can be updated automatically according to the scheduled refresh.

Best Regards,
Angelia