Power BI Data Source Configuration & Authentication - Office 365 Excel (OneDrive)

Hello All,

We have a data source for connecting Office 365 Excel stored in OneDrive. Below is the detail

File Path - OneDrive Path for Office365 Excel file (.xlsx)

Credential - Organizational Acount

Privacy Level - Organizational

This is  working fine in Power BI Desktop but after deployment to myWorkspace. not able to refresh datatset. We have tried all options for authentication & Privacy levels but didn't worked. Power BI servces giving below options for authentication & Privacy levels:

 Kindly suggest based on above available options how to configure the data source in Power BI service similar to one (data source) which is working in Power bI Desktop. or any alternate solution.

Thanks,

PBI V2