Unanswered

Trying to connect to dataverse project file

(0) Share

Report

Posted on by BG-10121624-0

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:

Power Query

I have the same question (0)

All responses (2)

Answers (0)

Sort by

SaiRT14 1,992 Super User 2025 Season 1 on at

Like (0)

Report
Copy link

Link copied!
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.

Was this reply helpful? Yes No
BG-10121624-0 2 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No