topic Re: Creating A Power BI App – missing fields in Developer

Creating A Power BI App – missing fields

Shreyas1902 — Tue, 11 Jan 2022 20:48:49 GMT

Hi –

We are trying to create a Power BI Template App that will work for many users. The sample data set we have has a number of custom fields so that the sample reports demonstrate many great visuals. However, not all users of the App will have those fields. We recognize that some visuals using the custom fields will be broken, but that should not be an issue.

In our testing of the App, when we connect to a new data source that does not have all fields, the refresh fails with error:

“Processing error The column 'XXXX' of the table wasn't found.”

Is there a way to configure a Template App so that it ignores missing fields?

Re: Creating A Power BI App – missing fields

lbendlin — Thu, 13 Jan 2022 01:18:33 GMT

Append a question mark to the column name selector when you manipulate it in Power Query. Instead of

[Column a] + [Column b]

you can write (assuming that column b is sometimes missing)

[Column a] + [Column b]?

That will yield null if the column is missing.

Re: Creating A Power BI App – missing fields

Anonymous — Fri, 14 Jan 2022 06:26:50 GMT

HI @Shreyas1902,

Perhaps you can try to manually define a table template to initialization, then you can load correspond table records from the response table to the template.

Chris Webb's BI Blog: Creating Tables In Power BI/Power Query M Code Using #table() Chris Webb's BI Blog (crossjoin.co.uk)

Sample code:

Custom1 = Table.Combine({Source,#table(type table[A,B,C,D,E],{})}

Source table:

Result:

Notice:

1. The right one is the template table with all fields.

2. ' Table.combine' function will add all the fields to the result table, the columns that do not exist in the raw table will be filled with null values.

Regards,

Xiaoxin Sheng