Query Folding Breaks on Unpivot

[jpilson32]

Hello,

I'm having an issue with my data refresh. My data sources are both erroring out on the Unpivot step(Dataverse & On-prem SQL). I keep getting the error:

"Microsoft SQL: The type of column "COLUMNX" conflicts with the type of other columns specified in the UNPIVOT list."

I also noticed that the "View Native Query" option is greyed out on the "Unpivoted Other Columns" step within Power BI Desktop. I'm able to get everything to work perfectly fine within Desktop, but as soon as I try to refresh the data within the Power BI Service, the refresh fails with the above error.

Are there changes I can make within the "Advanced Editor" window that will allow the query folding to work as intended instead of breaking?

[aj1973 · Accepted solution]

Hi @jpilson32 

Before the Unpivot Step, you might want to check/modify the type of the columns' Table.

there is a conflict somewhere

[jpilson32]

I tried that, I have everything set as text except for the date columns. It really doesn't like the "Unpivot" step because everything leading up to it has the native query functionality.