Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello guys,
I am building a dashboard right now and have some data sources on a SQL server. One table contains more than 6 million rows, so I thought that I split this table in two different tables for a faster updating in the night.
I have the data from 2013 till 2018 which I want to load one time in Desktop. This table shouldn´t be updated in Service then anymore.
The second table contains the YTD sales data, which should be updated every night.
So in Desktop I saw the function "Include in report refresh" which I want to disable for the first table. Is that possible to do that in Power BI Service as well?
Thanks and greetings,
Christopher
Hi Christopher,
I would suggest you take a look at the incremental refresh capabilities of Power BI as to my knowledge the "Include in report refresh" only applies to Power BI desktop.
https://docs.microsoft.com/en-us/power-bi/service-premium-incremental-refresh
I haven't seen anything on the roadmap but if you feel it's a necessary feature, go vote for the idea
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/20579641-exclude-a-table-from-ref...
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.