Power Query Dataverse Connector Table List Not Listing All Tables

(1) Share

Report

Posted on by SurfaceWear

186

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:

Power Query

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Suggested answer

Michael E. Gernaey 53,963 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

HI

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

Was this reply helpful? Yes No
SurfaceWear 186 on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Verified answer

SurfaceWear 186 on at

Like
a
(0)

Report
Copy link

Link copied!

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)

1 people found this reply helpful.

Was this reply helpful? Yes No