web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Pages
Suggested Answer

Invalid credentials

(0) ShareShare
ReportReport
Posted on by 36
I hope this email finds you well.
 
 
I had an issue trying to import SharePoint lists into my Dataverse table in a Power Platform environment. (see attached screenshot).
 
Any assistance would be greatly appreciated.
 
YK
Screenshot 2025-07-24 160434.png
Screenshot 2025-07-24 152758.png
Categories:
I have the same question (0)
  • Suggested answer
    Jon Unzueta Profile Picture
    1,834 Super User 2026 Season 1 on at

    erroI'd be happy to help with your issue importing SharePoint lists into Dataverse — but it looks like you mentioned an attached screenshot, and I don’t see one here. Could you please upload the screenshot again? That will help me understand the exact error or issue you're encountering.

    In the meantime, here are a few common things to check when importing SharePoint lists into Dataverse:


     Checklist for Importing SharePoint Lists into Dataverse

    1. Permissions

      • The error show that yi havent access to Excel. Ensure you have appropriate permissions on both the SharePoint site and the Power Platform environment.
    2. List Configuration

      • Make sure the SharePoint list is not using unsupported column types (like calculated fields, lookup columns to external lists, etc.).
    3. Connector Setup

      • Confirm that the SharePoint connector is properly authenticated (using Microsoft Entra ID or OAuth).
    4. Environment Region

      • The SharePoint site and the Power Platform environment should ideally be in the same region to avoid latency or compatibility issues.
    5. Data Types

      • Dataverse may not support certain SharePoint column types directly. You might need to map or transform them during import.
    6. Using Power Query

      • If you're using Power Query to import, ensure that the query loads correctly and that the preview data appears as expected.
    🏷️ Tag me if you have any further questions or if the issue persists.
    ✅ Click "Accept as Solution" if my post helped resolve your issue—it helps others facing similar problems.
    ❤️ Give it a Like if you found the approach useful in any way.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Pages

#1
DP_Prabh Profile Picture

DP_Prabh 51

#2
rezarizvii Profile Picture

rezarizvii 35

#3
oliver.rodrigues Profile Picture

oliver.rodrigues 29 Most Valuable Professional

Last 30 days Overall leaderboard