Direct Query "Can't display the visual" in direct query with only 4.000 rows

[KasperJ90]

Hi,

I am trying to build a report with direct query on my sales table. The sales table is only 4.000 rows in a SQL database in Azure. In Power BI Desktop I have made a one to many relationship between a sales date in my sales table and my date table. When I try to add "Finance Year" from my date table linked to the sales table it fails. Why? The data tables includes only 5.000 dates.

[lbendlin]

Check the relationship arrows. Can you get "from here to there"  or is your data model blocking the path?

Sometimes you can mitigate the issue by adding a measure to the visual.

[NeedhelpBI]

Hi @lbendlin 
Not sure what you mean. I have a one to many relationship between my date table and my sales table.
I have only one date in my date table and many dates (posting dates) in my sales table. The direct query report works until I add something like "Finance Year" or "Year" from the date table. But why can it not run this simple direct query?

[lbendlin]

Yes, that should work.  What do you see when you click "see details"  ?

[NeedhelpBI]

Hi,
I get this error

Couldn't load the data for this visual
Activity ID: 60441d2f-c400-49c7-92a4-1cebed9b13bb
Request ID: 846c38d8-35df-4568-8f05-b8cb2dc6ba48
Correlation ID: 892d74c1-7e86-9c19-bf1e-5e5ef83c3a60
Time: Mon Oct 02 2023 15:52:43 GMT+0200 (Central European Summer Time)
Service version: 13.0.21669.112
Client version: 2309.4.15949-train
Cluster URI: https://wabi-europe-north-b-redirect.analysis.windows.net/