Error only in service portal NOT in Desktop

[Frixel]

Hello all,

When i refresh my report in the Power Bi Desktop then it is okay and no errors.

When there is a refresh in tihe service portal i get this error.

What can i do to this?

Fout in de gegevensbron:	Expression.Error: <pii>The column '10-10-2021 16:39:22' of the table wasn't found.</pii>. <pii>10-10-2021 16:39:22</pii>. . The exception was raised by the IDbCommand interface. Table: Export File.
URI cluster:	WABI-NORTH-EUROPE-K-PRIMARY-redirect.analysis.windows.net
Activiteits-id:	00000000-0000-0000-0000-000000000000
Aanvraag-id:	4111ad0a-2e5c-44c3-9057-12c314626b30
Tijd:	2021-10-14 14:50:03Z

[v-henryk-mstf]

Hi @Frixel ,

According to the error message, this could be caused by steps such as you renaming, reordering columns, changing data types, deleting other columns, etc., as shown in the screenshot below:

Right click on your query then select Advanced editor. Here you can see the name of columns/object used for each step of your query, find the unfound column name and edit it.

Here is the similiar solution.

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[GilbertQ]

Hi @Frixel 

The error is indicating that it cannot find a column. And from the looks of it this column is a date time column which I am going to assume changes each time the data refreshes?