Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
vmakhija
Post Prodigy
Post Prodigy

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 in the table.

I checked Advanced Editor for both the tables and it is exactly same i.e. 

 

let
Source = Sql.Databases("XXXX"),
AdventureWorksDW2014 = Source{[Name="AdventureWorksDW2014"]}[Data],
dbo_DimDate = AdventureWorksDW2014{[Schema="dbo",Item="DimDate"]}[Data]
in
dbo_DimDate

 

Alternatively, if I do a Reference instead of Duplicate, I can see data appearing correctly.

 

Any idea what could be the reason or anyone faced this?

 

Regards

1 ACCEPTED SOLUTION

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.

捕获.PNG 

 

Regards,

Jimmy Tao

View solution in original post

6 REPLIES 6
v-yuta-msft
Community Support
Community Support

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

@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

Hi vmakhija,

 

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

 

Regards,

Jimmy Tao

@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 -

DC1.PNGDC2.PNGDD1.PNGDD2.PNG

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

I have uploaded the PBIX here -

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

 

Regards

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.

捕获.PNG 

 

Regards,

Jimmy Tao

@v-yuta-msft

That worked...

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

 

Regards

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.