1 separate tabel to refresh once per week

[SatchBoogie]

Hi

I have a pbix in the Service which is refreshed every day.

There's 1 table I don't want to refresh everyday (due to limits on the server end there)

How can I do the following:

Can I create another pbix with only that table, refresh that one once a week. And include that pbix(table) in the original pbix from above?

This one table is a download via an API with parameters so there needs to be some functions in it to make it work with refreshing.

Thanks in advance!

[SatchBoogie]

Thanks, that does the trick!

[MFelix · Accepted solution]

Hi @SatchBoogie ,

You can create a dataflow for that specific table and define the refresh to be once a week, then consume that dataflow instead of the table.

https://learn.microsoft.com/en-us/power-bi/transform-model/dataflows/dataflows-create