Forum Discussion
Issue with import and directQuery filter in visualisation
Hello !
I'm trying to simply filter a table visualisation with an other visualisation of two table linked by a 1-1 Both model connection.
In this case i just try to test between two identical tables.
The first one is a DirectQuery and the other one is imported.
Both from a SQL Server database.
in the report visualization i use two table with the column "Message" in both.
If i select a line in the ReportEventTimeTime it filter and display the same value on the table ReportEvent :
But if i do the oposite it's not working displaying any values
Some one have an idea
Thank for your responses !
2 Replies
Based on your description and screenshots, it looks like you are trying to filter an imported table visualization using a DirectQuery table visualization. This might not work as expected because the two tables have different data loading modes, and therefore different behavior when filtering.
When you filter the DirectQuery table visualization, it sends a query to the database and returns the filtered results. However, when you try to filter the imported table visualization, it needs to work with the data already loaded into memory, and this data may not contain the filtered values.
To solve this issue, you can try changing the data loading mode of the imported table to DirectQuery, so that both tables have the same data loading mode. Alternatively, you can try creating a relationship between the two tables in the model view of Power BI, and using the related fields to filter the imported table visualization. This should work regardless of the data loading mode of the tables.
Thank you for your answer !
So power Bi can't mix request between DirectQuery and Imported ? Is it what you meant ?
Is the screen shots the values in both tables are identical between ReportEvent and ReportEventTimeTime.
