Forum Discussion
Error in refreshing dataflow - cannot resolve conflict
Update for the community:
It ended up having to do with some kind of implicit data type casting before the unpivot step. The data tupes coming in from the linked table look perfrectly fine. But then the unpivot step fails. I simply tried to do a 'detect data type' step before the unpivot!
Solved. Not sure what's going on but linked tables (from other data flows) somehow can give some challenges here and there.
Hi lbendlin - it doesn't work like that for me unfortunately. When I right click the steps I don't see that option: there is 'View data source query' and 'View query plan'. The first one is greyed out in every step. The second seems to provide just a visual representation of the query steps.
Edit: to your question on running the sql query? if I could find it, I also wouldn't know how to do that as I think it is something PBI/power query does in the background with the dataflows. Maybe that to some extent uses a sql instance, no idea... I wouldn't know how to run that though...
And I don't understand the question about collation. I just need those steps to get to my final output.
Please note I'm working online with data flows.
As I'm using linked tables guess that's what's causing some query folding (compute engine is set to the standard setting).
You should be able to take the Power Query code from the dataflow and duplicate it in the Power Query editor of the Power BI Desktop. Makes troubleshooting easier.