Power Query Dataverse Connector Table List Not Listing All Tables

Like (1) Share

Report

Posted on 1 Oct 2024 20:20:05 by tfraser

177

Using Source = CommonDataService.Database(EnvUrl) - the list of tables is incomplete.

Some relatively recent tables are missing - tables I added about a week ago. I have full access to everything so it's not a permission issue. I'm definitely looking at the correct environment.

The same tables are appearing in other environments but not this one.

Has anyone come across this and found a solution?

Categories:

General Comment

All responses (3)

Answers (1)

Verified answer

tfraser 177 on 10 Oct 2024 at 15:03:50

Like (0)

Report

Power Query Dataverse Connector Table List Not Listing All Tables

Found the solution in another thread - it's the Environment was in Administration mode. Once I disabled that, the new tables and columns appeared.

Solved: Power BI Dataverse connection, not all tables present. How to solve this? (powerplatform.com)
tfraser 177 on 10 Oct 2024 at 14:35:25

Like (0)

Report

Power Query Dataverse Connector Table List Not Listing All Tables

Hi @FLMike - I don't think I've ever used the 'Publish All Customizations' button before when not inside a solution!

I clicked this a few days ago and have just got round to refreshing the PowerBI report and I'm getting the same error.
Suggested answer

Michael E. Gernaey 38,788 Super User 2025 Season 1 on 03 Oct 2024 at 03:17:11

Like (1)

Report

Power Query Dataverse Connector Table List Not Listing All Tables

HI

Only saw it when I hadn't published all customizations from the Solutions Tab (not your solution)