Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
Hi Experts,
I have few reports in Power BI service which is reading data from the excel files store on SharePoint Team sites.
I used the SharePoint folder connector to read the excel file. The refresh to these reports was schedule which suddenltly got disabled due to credential issues.
When I try to re-enter the credentials using oauth I get the following error:
The OAuth authentication method isn't supported for this data source. Contact your admin.Show details
Tried few different reports in different workspace and in premium workspace too. Nothing seems to be working and looks like all the reports reading data from the excel st
I have the same issue now and then, its fixed without doing anything special, just opening the settings of another dataset and then returning and opening once again the settings of the dataset that faces the issue solved it for me.
Hi, @skygold16
When connecting to data sources and services that require authentication through OAuth or Azure Active Directory-based authentication, in certain cases where the service is configured correctly, you can use the built connectors to authenticate and connect to data without requiring a service-specific or custom connector.
Power Query SharePoint list connector - Power Query | Microsoft Learn
More details: Authentication with a data source - Power Query | Microsoft Learn
I have also found a similar post, please refer to it to see if it helps you.
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.