Forum Discussion
Dataflows and "Complex Columns"
So I figured out it was because of power query transform steps that were changing a date/time column to be formatted as time only. That caused the warning and I assume created the "complex column". Once I deleted those steps the data flow was finalized and saved.
Now my problem is that when I open Power Bi desktop and try to attach to that dataflow as a source, my credentials that I have used in PBI desktop to sign in with are not the ones being recognized. It is taking me to my test dataflow that was built on a different O365 tenant space, under completely different credentials. I tried switching user and then back, still goes to that original dataflow.
So I figured out it was because of power query transform steps that were changing a date/time column to be formatted as time only. That caused the warning and I assume created the "complex column". Once I deleted those steps the data flow was finalized and saved.
Now my problem is that when I open Power Bi desktop and try to attach to that dataflow as a source, my credentials that I have used in PBI desktop to sign in with are not the ones being recognized. It is taking me to my test dataflow that was built on a different O365 tenant space, under completely different credentials. I tried switching user and then back, still goes to that original dataflow.
I have encountered the same issue of "Complex columns not loaded" can you please provide some more help as i am a begginner and i cant get what you meant by power query issue resolved.
Please it's a humble request if you can provide me some sort of more help.
Thanks