Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Apps - Power Query
Unanswered

Trying to connect to dataverse project file

(0) ShareShare
ReportReport
Posted on by 2
I work for a government entity, and am in the gcc (government cloud).  I'm trying to connect power query (via my desktop version of MS Excel) to a project file in the Dataverse.  I was able to successfully connect (it appears), but I don't see any files in the "Dataverse" results list (just the folder "Dataverse" appears). Any thoughts?  
Categories:
  • BG-10121624-0 Profile Picture
    BG-10121624-0 2 on at
    Trying to connect to dataverse project file
    SaiRT14,
    Thanks for the quick response. I went to the Make Portal link provided, and received the following error:
     
    Sorry, there's been a disconnect
    The email address you have provided is associated with a Microsoft 365, Office 365, or Dynamics 365 U.S. Government Subscription. Please talk to your organization's Online Services Tenant Administrator if you would like to request permission to access Microsoft Power Apps U.S. government cloud environment.
     
     
    If I'm reading correctly, I need to go to my company's Tenant Administrator.  Let me know if interpreting incorrectly.
     
  • SaiRT14 Profile Picture
    SaiRT14 1,941 Super User 2025 Season 1 on at
    Trying to connect to dataverse project file
    Pls check 
    • Verify Table Settings: Go to Maker Portal (https://make.powerapps.com/). Open the environment you are working in. Under Dataverse > Tables, locate the table you want to connect to. Ensure the following: The Enable for OData option is turned on in the table’s Advanced Settings. The table is published.

    • Check Table Permissions: In the table’s settings, confirm that the table’s permissions allow the data to be read by your account.

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,318 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,111 Most Valuable Professional

Leaderboard

Featured topics