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
Sendilnathan
New Member

Embedded Power BI Reports does not show complete data

I have a report created with Direct Query with following models and relationship.

(1:* relationship with filter in both direction)

Sendilnathan_0-1623140361433.png

 

Am able to create a table visual with all rows from both table in Power BI desktop.

Sendilnathan_0-1623143796947.png

 

But when the same report published to Azure Power BI workspace and emedded into a web application does not show all data.

I can see data only

  • if columns are only from TimeTracking
  • if TimeStamp column is choosen with Latest or Earliest aggregation

 Sendilnathan_1-1623143846428.png

 

And If show items with no data is chosen, then rows are displayed with empty values as in below screenshots (2)

 Sendilnathan_0-1623144371999.png

 

Can someone help?

 

1 ACCEPTED SOLUTION
Sendilnathan
New Member

@V-lianl-msftThe issue resolved after changing Timestamp column datatype from DATETIME2 to DATETIME2(0)

View solution in original post

2 REPLIES 2
Sendilnathan
New Member

@V-lianl-msftThe issue resolved after changing Timestamp column datatype from DATETIME2 to DATETIME2(0)

V-lianl-msft
Community Support
Community Support

Hi @Sendilnathan ,

 

This may be caused by both filter direction of 1-*, which is usually filtered from 1 to *.

After trying to change the filtering direction, see if the problem still exists.

 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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.