Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Duplicate for DimDate table - Doesn't work

Hello Using AdventureWorksDW, I am trying to duplicate my query "DimDate". Though once I duplicate, I can see data appearing for the duplicated table, after doing "Close & Apply", I can see no data...
Need Help
  • v-yuta-msft's avatar
    v-yuta-msft
    8 years ago

    Hi vmakhija,

     

    I have reproduced your issue. The duplicate operation only duplicate info like Name, Data, Schema, Item and Kind, raw data in database will not be duplicate. So the solution is to refresh the table by clicking "Refresh" so that raw data will be import to power bi again.

     

     

    Regards,

    Jimmy Tao

v-yuta-msft's avatar
v-yuta-msft
Community Support
8 years ago

Hi vmakhija,

 

Modify M code like this and check if it can work:

let
    Source = Sql.Database("Server", "Database"),
    dbo_Table = Source {[Schema="dbo",Item="Table"]}[Data]
in
    dbo_Table

 

Best Regards,

Jimmy Tao

Anonymous's avatar
Anonymous
Not applicable
8 years ago

v-yuta-msft

I faced this issue with yet another table today. So, when I duplicate the table, the duplicated table shows no data in report design view.

Not sure what is causing it...

 

Regards

  • v-yuta-msft's avatar
    v-yuta-msft
    Community Support
    8 years ago

    Hi vmakhija,

     

    What's the error message, if possible, give me a demo file to test.

     

    Regards,

    Jimmy Tao

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      v-yuta-msft

       

      There is no error message.

      Its just that in "Data" view, there is no data for the duplicated table.

      See below screenshots -

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

      I have uploaded the PBIX here -

      https://1drv.ms/u/s!AhQweeNOVnlxbeGdqrGSt8GbLKI

       

      Regards

      • v-yuta-msft's avatar
        v-yuta-msft
        Community Support
        8 years ago

        Hi vmakhija,

         

        I have reproduced your issue. The duplicate operation only duplicate info like Name, Data, Schema, Item and Kind, raw data in database will not be duplicate. So the solution is to refresh the table by clicking "Refresh" so that raw data will be import to power bi again.

         

         

        Regards,

        Jimmy Tao