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,

 

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