Forum Discussion
Addressing Query Date Range Sync Challenges in Power BI Connected to BigQuery
Hello I'm new to Power BI and encountering an issue. I've connected a dataset via BigQuery (direct query) in Power BI Desktop. Since the dataset is large, I've included a WHERE clause in my query t...
Hi skhatib
What you need to do is to configure your Power Bi desktop with incremental refresh. This will then allow you to load all the day to that you need into your power BI semantic model. Here is a link explaining what incremental refresh is Incremental refresh for semantic models and real-time data in Power BI - Power BI | Microsoft Learn
Hi GilbertQ , Thank you for getting back to me. To implement incremental refresh, I'll need to switch my model to import mode. However, due to the large volume of data, import mode isn't feasible. I'm currently utilizing direct query. Shouldn't this setup work fine with the date table when connected to the semantic model and selecting dates in the slicer?
