Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities
Give Back to the Community this Month
Announcing Category Subscriptions!
News and Announcements icon
Power Platform Community / Forums / Power Apps - Power Query / Trying to connect to d...
Power Apps - Power Query
Unanswered

Trying to connect to dataverse project file

(0) ShareShare
ReportReport
Posted on by BG-10121624-0 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:
General Comment
Capture.PNG
  • 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,474 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

News and Announcements

Welcome to the Power Platform Communities
Give Back to the Community this Month
Announcing Category Subscriptions!

Quick Links

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #9 Get Recognized…

Welcome to a brand new series, Tuesday Tips…

more Community News

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,867

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 64,174

Leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans