Forum Discussion
Data Hub - updates to dataset, not data refresh
Good morning experts,
A bit of background.
- I work within a development team that builds PBI reports from a centralised data warehouse,
- This data warehouse is populated from data from across the organisation
- New tables are incrementally added into the data warehouse to build the respective functionality for the coming weeks.
- We're making one of these datasets available to a wider group of users so they can build their own reports.
We want to understand whether inbuilt Power BI functionality and specifically Data Hub can be used as a tool to update these users on the incremental update of a dataset, e.g. week 1 - tables A-E are added, week 2 - tables F-I, week 3 - nothing happens, week 4 - J-Z.
My understanding is that Data Hub will make the overall dataset visible to users and can advise whether/when the data within has been refreshed, but am not sure whether it has the functionality to notify specifically that the dataset has physically changed to include new tables, and what those changes were.
Obviously if we need we can communicate this manually but wanted to explore whether there was some form of in built / automated functionality within Power BI that might be useful to explore.
Thanks in advance,
Tim
2 Replies
HI timcorke,
I think the incremental refresh and filter by user parts are possible to be achieved on the power bi side.
Incremental refresh for datasets and real-time data in Power BI - Power BI | Microsoft Learn
Solved: RLS with UserName() - Microsoft Power BI Community
For newly added tables, they were not able to be automatically added to the current report. You still need to manually maintain and update the report to add new content.Regards,
Xiaoxin ShengHi Anonymous thanks for your reply - but this isn't really answering the question, and as such not sure how this has become an Accepted Solution.
I'm looking to understand whether Data Hub helps with the notification of users of specific changes to the tables being refreshed, not how to refresh data. Failing that, whether there was an automatic way of doing this?
