Forum Discussion

bubblesort's avatar
bubblesort
Regular Visitor
7 years ago

PowerBI Data Source Credential support AAD?

Hi all,   I have a pretty basic dataset consisting of a single OData source that I'd like to refresh daily. Currently I'm manually doing the refresh in the desktop app but would like to get it auto...
v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
7 years ago

Hi bubblesort,

 

Did you use the OData connector? Please refer to the snapshot below.

Power_BI_Data_Source_Credential_support_AAD

 

Best Regards,
Dale

bubblesort's avatar
bubblesort
Regular Visitor
7 years ago

Hi v-jiascu-msft,

 

I did use the OData connector. However, in the Authentication method dropdown I only see the first three options you screenshotted (Anonymous, Basic, WindowsWithoutImpersonation). I've tried all three of them but none of them seemed to get through the authentication on the OData service end. I spoke with the service supplying the data and they said that PowerBI needed to support AAD when fetching the data for auto refresh.

 

Thanks,

Cecille

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    7 years ago

    Hi Cecille,

     

    I tested it again with a new data source. If I authenticate the connection with Organization Account in the Desktop, the Auth2 will appear in the Service. Please refer to the snapshot below.

    BTW, It's Organization Account in the Desktop which is AAD authentication.

    Power_BI_Data_Source_Credential_support_AAD2

     

    Best Regards,
    Dale