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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Loading a large excel ...
Power Apps
Answered

Loading a large excel table as a virtual dataverse table

(0) ShareShare
ReportReport
Posted on by 256

Using the virtual connector (set up here: https://docs.microsoft.com/en-us/power-apps/developer/data-platform/virtual-entities/create-virtual-tables-using-connectors?WT.mc_id=BA-MVP-5000177&tabs=sharepoint#create-the-connection) with a table being referenced in Excel, I get this error, "String primary keys are supported only if they can be parsed as GUID." What do we need for a primary key in an Excel table. Does it need to be unique?

I have the same question (0)
  • Verified answer
    Guido Preite Profile Picture
    1,488 Super User 2024 Season 1 on at

    For example you can add a new column inside your excel and use this kind of formula to generate a random GUID https://stackoverflow.com/questions/14990236/how-to-create-a-guid-in-excel

    hope it helps

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 765 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 343 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 272

Last 30 days Overall leaderboard