Forum Discussion

Arunthathi's avatar
Arunthathi
New Member
7 months ago
Solved

How to create custom error messages for missing tables/columns in Power BI Template App

Hi Community, I am building a Power BI Template App connected to Snowflake. In Power BI Desktop, when required tables or columns are missing, the error message clearly shows which table/column is m...
Need Help
  • cengizhanarslan's avatar
    cengizhanarslan
    7 months ago

    You generally cannot reliably surface those custom refresh-time errors as a report visual in the Service, because when refresh fails, the dataset/model isn’t updated, and visuals can’t render “new” status coming from that failed refresh. In Template Apps, users often only see the generic refresh failure summary.

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
7 months ago

You cannot use error handling for missing tables. These always require a manual meta data refresh.

 

There are functions in Power Query to handle missing columns, however the final query output meta data will be cached which will again result in an error message that you can only clear via a schema refresh.