cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
kbuckvol
Helper I
Helper I

Tables in Edit Query grayed/italicized, duplicate table query missing

I wonder if anyone else has had this quirky issue:

 

I have a Power BI file that we have been using for about a year, there are about 9 tables pulled in from Excel with relationships and queries set up.  It has been running really smoothly and then all the sudden, a couple of weeks ago, one of my queries seems broken.  The broken table source is an Excel table and this table is also used as a Duplicate Query with filtered rows.   I had added calculated columns and measures to the original table and in the past, those columns have passed to the duplicated table.  Currently, the original table is italicized in the Edit Query window and the duplicated table is missing in the list of queries.  In the report view, the original table is missing but the queried table is there though the calculated fields are all broken because they reference the original table.

 

I have attempted to rebuild this file by pulling in the source table, adding calculated fields but now they are not being passed to the duplicated table.  Funnily enough, in other files, this table and it’s duplicate do not have issues.  My search produced the suggestion of checking “Enable Load”, my table currently has this unchecked, I have attempted to click this and get a message saying "Possible Data Loss Warning" about disabling, even though this is currently not enabled.  On my new rebuild file, selecting this option has not solved the issue of the calculated columns being carried forward to the duplicated table .  https://community.powerbi.com/t5/Desktop/Some-Tables-are-Greyed-out/td-p/135678

 

About the Excel table: we get regular updates of this table and I process it and replace the old with the new, so it’s not necessarily the same table, it just gets replaced.  This process has not changed and I haven’t done anything differently than what I have been doing all year.

 

I’m at my wit’s end.  I can’t fix and I can’t rebuild what we had and I’m sure it’s one or two settings that I’m not selecting!

5 REPLIES 5
v-xicai
Community Support
Community Support

Hi  @kbuckvol ,

 

Does that make sense? If so, kindly mark my answer as a solution to help others having the similar issue and close the case.

 

Best regards

Amy Cai

v-xicai
Community Support
Community Support

Hi @kbuckvol

 

Once you replicate the original table by duplicating a query , please click "Close and Apply". If the color of replicated table is grey, then click the "Enable load" to take the replicated table loaded into the Data Model, which will be seen in Report view, Data view and Model view. After that, you can begin to create calculated columns or measures.

 

7.png 

 

 

 

 

 

8.png

 

 

 

 

 

 

Best Regards,

Amy

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

This situation occurred in one of my reports and Amy's solution worked to correct it.  Thanks, @v-xicai Amy!

Thanks for your reply!  Yes, this is what is supposed to happen...but is not.  I'm trying to troubleshoot why this normal process all the sudden stopped workin after a year with no problems.

v-xicai
Community Support
Community Support

Hi @kbuckvol

 

Please check the version of Power BI Desktop on your side, and the try it again after updating to the latest version 2.68.5432.841.

 

Best Regards,

Amy

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

April Update

Check it Out!

Click here to read more about the April 2021 Updates!

MBAS Carousel

Sign up for our May 4th event!

May the fourth be with you, join us online!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.