Forum Discussion
RezaAssadi
1 year agoMicrosoft Employee
Getting transient Null Exception when refreshing a data source
I keep getting the error below when I do a full refresh on my Power BI report. However, refreshing the data source individually works without any issue. OLE DB or ODBC error: [Expression.Error] ...
vojtechsima
1 year agoSuper User
RezaAssadi hello,
do you have some dependency on some tables, or are you waiting for some query to finish before you get values for another one, that's the only thing I can think of.
- RezaAssadi1 year agoMicrosoft Employee
I do have different references between different tables. However, that used to work just fine before and I am not entirely sure why it would only break if I refresh all Data Sources at once (and not when I just refresh this one data source). What's more challenging is that there are no error logs telling me which column has a null reference and where that null reference is. I verified the underlying query and confirmed none of the columns are null.