Forum Discussion

oBi1's avatar
oBi1
Helper I
1 year ago
Solved

Error in refreshing dataflow - cannot resolve conflict

Hello!   I'm hoping someone can shed some light on this and help me resolve it.   Environment: PBI service, PPU workspace Dataflows (simplified): 1) load excel file from sharepoint 2) some tra...
Dataflow
Need Help
  • oBi1's avatar
    oBi1
    1 year ago

    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.

oBi1's avatar
oBi1
Helper I
1 year ago

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.