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

That worked...

Any idea why the normal duplicate didn't work for me?

 

Regards