Forum Discussion
Datasize and refresh problem
Anonymous , The way to do is we load small data in the desktop file and load data in service.
Incremental ETL https://docs.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-overview
Hi Anonymous
the problem is kind of solved. First I've learned PBI doesn't save/export changes to the data if you refresh it on the report server and download it afterwards. This feature seems to not exist.
So my first solution was the one I described earlier, to only refresh it on report server and do a "sql-view" solution like guy in the cube mentioned in his video ( by having 2 folder, one with all data and one with testdata - renaming them whenever I work on desktop with PQ )
But after a little bit more search I found out I could use parquet files to decrease filesize and now I'm loading the whole data even on desktop. I might changes this in the feature and combine it with the view-solution but for now this has to be good enough.
I would have loved to try all the other solution with incremental refresh/live datasets and so on but unfortunatly our corperate version doesn't support any of those.