Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Dataflow refresh fails (but no errors in preview)

Good day,   I am working on extension of one of my dataflows but I faced a problem I am not able to solve. I have a dataflow which pulls data via an API (it's a REST API providing employees' data)...
Dataflow
  • Anonymous's avatar
    Anonymous
    3 years ago

    The issue seems to be caused by the fuction returning details of each employee contract. It was returning a 1-row table which seem to be fine for power bi desktop and dataflow preview but dataflow refresh requires a record type to be returned (so that it can be expanded into additional columns).

     

    Is it a bug or a feature? Do anyone know some source where I couls find more details about this behavior?

Anonymous's avatar
Anonymous
Not applicable
3 years ago

The issue seems to be caused by the fuction returning details of each employee contract. It was returning a 1-row table which seem to be fine for power bi desktop and dataflow preview but dataflow refresh requires a record type to be returned (so that it can be expanded into additional columns).

 

Is it a bug or a feature? Do anyone know some source where I couls find more details about this behavior?

  • tnemeth's avatar
    tnemeth
    Frequent Visitor
    1 year ago

    I made a topic VERY SIMILAR to this earlier this week. Clearly I didn't see your topic at the time.

     

    Unfortunately (?) I have no idea what you meant and I started to google different things and one thing led to another and I ended up clicking 'Options' 'Privacy' and then 'Allow combining...' and that fixed my problem. I'll write a more detailed explanation in the topic I posted...

     

     

    I DON'T think that what I discovered is entirely relevent to what you were saying your problem was but:

    a) It could be -- I don't know enough to know it isn't

    b) Reading your post set my google searches on the right track to get me to my answer - so thanks!