Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi All,
I have a report built on two tables. First table brings 2019 data and second table brings 2020 data. I have now combined both these tables into one single table.
Now , when cIick on Refresh model in Power BI, or when I set up schedule refresh in the Power BI service, I do not want the 2019 data to be refresh, I would like to refresh only the 2020 data and keep the 2019 data as static.
Note: I have unchecked Include in report refresh
Tables used are :
Could someone please let me know how to achieve this.
Thank you
Poojitha
@Anonymous
You seem to have disabled load on the 2019 table in PQ, which works only in the desktop refresh scenario. If you need to selectively set the refresh for each entity, try Dataflow:
https://radacad.com/what-are-the-use-cases-of-dataflow-for-you-in-power-bi
Another option to consider is the Incremental Refresh option:
https://docs.microsoft.com/en-us/power-bi/admin/service-premium-incremental-refresh
Vote for an Idea: https://ideas.powerbi.com/
________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Also, the report is already developed completely.
As I am new to the concept of dataflow, can you suggest if there will be any rework on the developments.
@Anonymous
Please refer to these articles after evaluating the possibility of getting results as expected.
https://exceleratorbi.com.au/moving-queries-from-power-bi-desktop-to-dataflows/
https://docs.microsoft.com/en-us/power-query/dataflows/how-to-migrate-queries-from-power-query-desktop-to-dataflows
________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Thanks for the reference documents. From reading the articles I understand that dataflow has to be created on the sources and now the dataflows should be consumed in the Power BI for reporting.
As in my case, the report was already built and live and shared to the targert audience and now when the schedule refreshing is happening , the refresh is failing with timeout error as the datasource is not allowing the huge data which is coming for the year 2019(1,31,000 records). Hence I wanted to turn off the refresh for 2019 and allow only 2020 refresh to happen.
Note : My source here is REST API and this api does not allow pulling of data from the source with large dataset which exceeds 5min of extraction.
Could you suggest what the best approach would be in my case as using dataflows will be a redevelopment again..
Incremental refresh does not support with the data source I am using. and Dataflows may be a new thing for us to implement in our project,
As a workaround, is there any other option I could do ?