Manual refresh - does it support incremental refresh?

Power BI
1

**

Hi Experts,

I am currently working with large fact table stored in a SQL database. The table is around 14M records. The data is a rolling 12 months and is refreshed weekly.
Currently, the data is refreshed manually, because we don’t have a gateway to server, and report gets published to a premium workspace.

Each time we need to refresh the data, we are reading 14M records, which takes a while to load, and at times we get the “no disk space” error. I want to introduce incremental refresh, can this be done at all without a gateway, and if yes, what is the best way to go about it?

Thank you all

Cheers,
Erika

2

Bumping this post for more visibility.

3

Hi @ErikaLoz

As I understand, Incremental refresh can be done only inside Power BI Service. Setup is done inside Power BI desktop but actual happens once it is published to service.

Thanks
Ankit J

4

Hi @ErikaLoz, did the response provided by @ankit help you solve your query? If not, how far did you get and what kind of help you need further? If yes, kindly mark as solution the answer that solved your query. Thanks!

5

Thank you Ankit,

I suspected as much :weary: