Forum Discussion
Helper ICannot see duplicate tables
I was able to replicate the issue by duplicating a query and apply "Close and Load", without making any changes to the duplicated query.
Not only with csv input, but also with other queries.
My best guess would be that it is related to lazy evaluation, as the duplicate is exactly the same as the original.
As soon as make any changes to the duplicated query, it loads normally.
So the question is why you would want to have 2 queries that are exactly the same?
Community ChampionYou mean if you load the tables into the data model, one of the tables has data and the other one has no data (i.e. it has rows and they are all blank)?
If you duplicated the query without any changes, then that seems highly unlikely to me.
Typical situations with the described phenomenon are:
1. The column types in the query editor don't correspond with the actual values.
(E.g. the column type is Int64.Type (Whole numbers) and your values have decimals).
2. You have blank rows in your table, that sort somewhere at the end in Power Query, but on top in the data view.
Helper IHi Marcel,
No, all the tables have data, at least they all have visible data in the query editor. It doesn't even show rows in the table visual.
I haven't changed the data types from what they are in the original table. I simply just duplicated the table.
Below are the images of my query editor and report view.
I have been able to get the data by just importing it again but it's just a bit redundant.
Thanks for the help.
Conor.
v-huizhn-msftMicrosoft Employee
Hi ConorHG,
Have you clicked "Apply" in Query Editor? Only the data is changed successfully after you click "Apply". Please see the following screenshot.
Best Regards,
Angelia- ConorHG
Hi v-huizhn-msft,
Yes, I've clicked apply. This has been happening for any csv I have tried to duplicate not just this one.
I have worked around the issue but I'd still like to figure out what was causing it.
Thanks,
Conor.- MarcelBeug
I was able to replicate the issue by duplicating a query and apply "Close and Load", without making any changes to the duplicated query.
Not only with csv input, but also with other queries.
My best guess would be that it is related to lazy evaluation, as the duplicate is exactly the same as the original.
As soon as make any changes to the duplicated query, it loads normally.
So the question is why you would want to have 2 queries that are exactly the same?