Forum Discussion

paulsnet1986's avatar
paulsnet1986
Icon for Helper I rankHelper I
2 years ago

Dataflow Column Blank Upon Refresh Completion -SOMETIMES-

Got a really frustrating issue - We have some data from a SAP Hana DB that we made available in a Power BI Dataflow and have used said data to create and publish some critial Power BI reports. The da...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Are you relying on database tables that get periodically updated?  I've run into troubles in the past where i'm using tables that get transformed by a database process and sometimes that process takes longer than expected.  When that happens, Power BI is using incomplete data and therefore can have outcomes like you have noted.

If you have a database team, check with them about your source tables (start with the big transacational ones) and see what they process end times are.  Maybe you need to bump your refresh times to be a bit later.