Forum Discussion

nait's avatar
nait
Frequent Visitor
3 years ago

Hybrid mode with Direct Query

I created a hybrid Power BI dataset that has both import mode (incremental refresh) and direct query; Import mode has data from Apri1 until yesterday, and Direct query has today's data only. 

Then I successfully created a new report connecting to the dataset by Live connection.

 

But after switching this new report from Live connection to Direct query and added a new column, this new column doesn't work as a filter or a slicer. When I use the filter, the result shows today's data only and past data disappeared from the report. 

 

I wonder if this is a bug or if anybody could help me with this isssue.

Thank you!

 

Need Help

3 Replies

  • nait's avatar
    nait
    Frequent Visitor
    3 years ago

    Hello GilbertQ 

     

    When I use LIVE connection, the report can pull both import data (data up until yesterday) and DirectQuery data (today's data only) from the PowerBI dataset as a data source. 

     

    When I switch the report to DirectQuery and add a column, it still shows both Import and Direct data from a PowerBI dataset. But I cannot use the new column as a filter. When I try to use this column as a filter, the report shows only today's data, and past data is excluded even if the data match the filter selection.

  • GilbertQ's avatar
    GilbertQ
    Super User
    3 years ago

    Hi nait 

     

    What happens if you had to change it back to Live Connection?

     

    The reason is that the live connection will use both import and DirectQuery. When you only have DirectQuery it uses only the DirectQuery data?

  • GilbertQ's avatar
    GilbertQ
    Super User
    3 years ago

    Hi nait 

     

    To me it would then indicate that you need the table where you are using that column as a filter to be in Dual mode for it to work as expected.