Forum Discussion

ConorHG's avatar
ConorHG
Icon for Helper I rankHelper I
8 years ago
Solved

Cannot see duplicate tables

Hi All,    I have imported a CSV and duplicated it within the query editor and can see the data correctly. Yet when I try to create a table using the duplicated data the data is blank?    Any hel...
  • MarcelBeug's avatar
    MarcelBeug
    8 years ago

    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?

     

     

ConorHG's avatar
ConorHG
Icon for Helper I rankHelper I
8 years ago

Hi 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-msft's avatar
v-huizhn-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

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's avatar
    ConorHG
    Icon for Helper I rankHelper I
    8 years ago

    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's avatar
      MarcelBeug
      Icon for Community Champion rankCommunity Champion
      8 years ago

      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?

       

       

      • ConorHG's avatar
        ConorHG
        Icon for Helper I rankHelper I
        8 years ago

        Thanks for the help. 

         

        I am trying to use this table as a lookup for several columns in my original data table. These columns contain the same data but could have different values at one time, hence using the same queries.

         

        From what I understand I can only use 'related' when I have a relationship between two tables. Can you only use one relationship at a time from the same column?

         

        So I found this the easiest way without merging the data to the one file first. 

         

        Thanks, 
        Conor.