DataFlow Refresh Error

[DexterG_RxS]

Hello,

A dataflow I set up several months ago started failing recently.  

Here is the error I got for each of the failures: 

Error: The column 'Rec&Insp / KBN' of the table wasn't found. Request ID: 51e764da-1052-468a-... Activity ID: 202c8a46-8aa0-...

In the dataflow, the inventory detail table is merged with the workorder table based on item number.  While it's possible this column will exist, it's also possible it won't (it is made up of the inventoy location / status).  

There is no reference whatsoever to that column in either the primary or any subqueries for this dataflow.  I confirmed by pasting the code from advanced editor into word and searched for KBN.   Again, not a single step references this column.  I stepped through each of the query steps until I found the one creating the error.  They all ran fine - no error was returned.  Only after saving the dataflow (despite making no changes to anything)... and pressing refresh in the prompt that follows every save, did the query run successfully. 

Any ideas why the service would return this false error and cause the dataflow to fail... better yet how to prohibit this from happening again?

Thanks in advance,

Dexter   

[AbbasG]

@DexterG_RxS Hi, it will not display false errors 😅 I came across a similar error a few days back.

The column name of one of the tables was changed which caused the dataflow refresh to fail. 

As per my understanding, you need to re-check it again, if the problem persists try raising a ticket with Power BI support.

[DexterG_RxS]

Thanks @AbbasG 

I appreciate you responding. 

If I understand you correctly, using the pivot column function in the query will doom your dataflows to fail unless all the datapoints are exactly the same every time it runs and despite never referencing the columns it creates within the query.  

Does this sound right to you?