i query 3+ different data sources, which all need to have different refresh schedules.
all this data should be available through one dataset, for report builders.
I initially thought i could solve this with a ETL data flow, but alas (happy to learn, please tell me if i am wrong!):
how can i achieve this:
different refresh times --> minimum refresh time --> live connection:
source2.pbix --> dataset+model.pbix --> reports.pbix
power bi data refresh is based on power bi dataset, it couldn't be based on data source.
you could set different schedule for one dataset, and when refresh the dataset, it will refresh all the datasource in it.
I don't suggest you put all the datasource into one dataset, that will lead to a very large dataset.
Hi Lin, thanks for your comment!
i found a reasonable way to connect Business central to a data flow, alas it's way more effort than on PBI Desktop. (per table: single odata source with per table credentials)
> power bi data refresh is based on power bi dataset, it couldn't be based on data source.
really? so if i refresh a dataset that consumes different data flows (for example: A:refreshed Daily, B:refreshed hourly, the refresh of the flows is always done when i refresh the dataset (hourly)? (--> A is then refreshed hourly?) that's terrible!
i thought it might be resonable to refresh some sources (data flows) e.g. once daily, and others once an hour. The report itself is then refreshed once an hour (the minimum freq data flow).
> I don't suggest you put all the datasource into one dataset, that will lead to a very large dataset.i want to pull certain "output" tables into the dataset, not all the source 🙂