• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

My Online Training Hub

Learn Dashboards, Excel, Power BI, Power Query, Power Pivot

  • Courses
  • Pricing
    • Free Courses
    • Power BI Course
    • Excel Power Query Course
    • Power Pivot and DAX Course
    • Excel Dashboard Course
    • Excel PivotTable Course – Quick Start
    • Advanced Excel Formulas Course
    • Excel Expert Advanced Excel Training
    • Excel Tables Course
    • Excel, Word, Outlook
    • Financial Modelling Course
    • Excel PivotTable Course
    • Excel for Customer Service Professionals
    • Multi-User Pricing
  • Resources
    • Free Downloads
    • Excel Functions Explained
    • Excel Formulas
    • Excel Add-ins
    • IF Function
      • Excel IF Statement Explained
      • Excel IF AND OR Functions
      • IF Formula Builder
    • Time & Dates in Excel
      • Excel Date & Time
      • Calculating Time in Excel
      • Excel Time Calculation Tricks
      • Excel Date and Time Formatting
    • Excel Keyboard Shortcuts
    • Excel Custom Number Format Guide
    • Pivot Tables Guide
    • VLOOKUP Guide
    • ALT Codes
    • Excel VBA & Macros
    • Excel User Forms
    • VBA String Functions
  • Members
    • Login
  • Blog
  • Excel Webinars
  • Excel Forum
    • Register as Forum Member

Get data from SharePoint Online List showing "We couldn't authenticate with the credential provided. Please try again" in some circumstances|Power Query|Excel Forum|My Online Training Hub

You are here: Home / Get data from SharePoint Online List showing "We couldn't authenticate with the credential provided. Please try again" in some circumstances|Power Query|Excel Forum|My Online Training Hub

Avatar
sp_LogInOut Log In sp_Registration Register
sp_Search Search
Advanced Search
Search
Forum Scope




Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
sp_Search Search
sp_RankInfo
Lost password?
sp_CrumbsHome HomeExcel ForumPower QueryGet data from SharePoint Online Lis…
sp_PrintTopic sp_TopicIcon
Get data from SharePoint Online List showing "We couldn't authenticate with the credential provided. Please try again" in some circumstances
Avatar
Chris Warren
Member
Members
Level 0
Forum Posts: 6
Member Since:
March 3, 2021
sp_UserOfflineSmall Offline
1
December 16, 2022 - 4:54 pm
sp_Permalink sp_Print

Hi all, I am having trouble with one of my Power Queries, which gets data from one of our organisation's SharePoint Online Lists. While it was working well it has started having issues with credentials. The problem is that I am getting seemingly endless "We couldn't authenticate with the credential provided. Please try again" towards the end of the queries execution. As if I wasn't already signed in a window pops up on the Anonymous tab, so I change this to the Microsoft Account tab and click [Connect]. It re-signs in fine, and the query starts to load again, only to ask for credentials again before it finishes.

I have checked the check the Data source settings and made sure the correct tab is selected and saved, it says Credentials Type: Organisational account and Privacy Level: Organisational. I've also checked the Query Options and tried "Ignore the Privacy Levels" and turning off Background Data load with no effect. It's as though I successfully sign in to the Microsoft Account but before the query finishes, the Sign In details are lost.

As a bit of context, in my case the raw SharePoint Online List is around 51,000 rows and I needed to see the data is several different representations in my workbook. I therefore created a "base query" that extracts all the rows from SP and also does all the cleansing and adjustments needed like renaming columns to match the display names and converting the UTC dates to local. This query is retained as Connection Only and not loaded into my workbook. I then created a separate set of scenario queries that reference the base query and applying the filtering I need for each.

What's interesting is that the smaller scenarios seem to load fine but where more than 5,000 rows are being returned it has these credentials issues. By the way I can export the data from within SharePoint without issue, but the resulting file is just too big for me to incorporate that worksheet into my spreadsheets.

Anyone seen or heard of this problem?

Avatar
Catalin Bombea
Iasi, Romania
Admin
Level 10
Forum Posts: 1800
Member Since:
November 8, 2013
sp_UserOfflineSmall Offline
2
December 20, 2022 - 2:34 pm
sp_Permalink sp_Print

Hi Chris,

Can you try again but with another browser set as default? If Edge is your default browser, change to Chrome or any other.

Avatar
Chris Warren
Member
Members
Level 0
Forum Posts: 6
Member Since:
March 3, 2021
sp_UserOfflineSmall Offline
3
December 21, 2022 - 9:16 am
sp_Permalink sp_Print

Hi Catalin, thanks for the suggestion. I did as you suggested and changed the default browser to Chrome, tested it to make sure Chrome opened when I clicked on a link, and ran the PQ again. The results were the same.

Avatar
Catalin Bombea
Iasi, Romania
Admin
Level 10
Forum Posts: 1800
Member Since:
November 8, 2013
sp_UserOfflineSmall Offline
4
December 21, 2022 - 3:28 pm
sp_Permalink sp_Print

That was my only suggestion unfortunately, never hit this problem

Avatar
Chris Warren
Member
Members
Level 0
Forum Posts: 6
Member Since:
March 3, 2021
sp_UserOfflineSmall Offline
5
December 23, 2022 - 2:37 pm
sp_Permalink sp_Print

Hi Catalin, I think I found the problem/solution. In my query I have a couple of ExpandRecordColumn statements to extract the user names contained within the Created By and Modified By columns. When I removed these steps the query ran without issue. After a bit of googling it appears that these statements are ok with nulls but do not like "" as a value. And as these were only included in my dataset as nice-to-haves, I could just leave them out without issue. Why this triggered a credentials error I can't say. Thanks for your help and suggestions though.

Avatar
Catalin Bombea
Iasi, Romania
Admin
Level 10
Forum Posts: 1800
Member Since:
November 8, 2013
sp_UserOfflineSmall Offline
6
December 23, 2022 - 3:20 pm
sp_Permalink sp_Print

Thank you for feedback Chris, nice to hear you managed to find a way out.

sp_Feed
Go to top
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 170
Currently Online: Alan Sidman, Bouskila stephanie, James Hwang
Guest(s) 65
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 1431
Anders Sehlstedt: 848
Velouria: 574
Purfleet: 412
Frans Visser: 346
David_Ng: 306
lea cohen: 213
A.Maurizio: 202
Aye Mu: 201
Jessica Stewart: 185
Newest Members:
David Collins
Andras Marsi
Orimoloye Funsho
YUSUF IMAM KAGARA
PRADEEP PRADHAN
Vicky Otosnika
Abhishek Singh
Kevin Sojourner
Kara Weiss
And Woox
Forum Stats:
Groups: 3
Forums: 24
Topics: 6047
Posts: 26543

 

Member Stats:
Guest Posters: 49
Members: 31497
Moderators: 2
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: MOTH Support, Riny van Eekelen
© Simple:Press —sp_Information
  • Excel
  • Excel Charts
  • Excel Dashboard
  • Excel Formulas
  • Excel PivotTables
  • Excel Shortcuts
  • Excel VBA
  • General Tips
  • Online Training
  • Outlook
  • Power Apps
  • Power Automate
  • Power BI
  • Power Pivot
  • Power Query
 
  • About My Online Training Hub
  • Contact
  • Disclosure Statement
  • Frequently Asked Questions
  • Guarantee
  • Privacy Policy
  • Terms & Conditions
  • Testimonials
  • Become an Affiliate

Copyright © 2023 · My Online Training Hub · All Rights Reserved

Microsoft and the Microsoft Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries. Product names, logos, brands, and other trademarks featured or referred to within this website are the property of their respective trademark holders.

Download A Free Copy of 100 Excel Tips & Tricks

excel tips and tricks ebook

We respect your privacy. We won’t spam you.

x