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!
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.
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.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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.
Check out new user group experience and if you are a leader please create your group
Click here to read more about the April 2021 Updates!
May the fourth be with you, join us online!
100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.