Forum Discussion

JonPBNES's avatar
JonPBNES
Icon for Helper I rankHelper I
3 years ago
Solved

Dataflows - "Information is needed in order to combine data" error

We have had a similar error occur a few times.    Created a dataflow for a sharepoint sheet (generated by forms, in this instance), security is set to 'none' on the connection.  Created an "enter ...
  • JonPBNES's avatar
    JonPBNES
    3 years ago

    To follow up on this, I tried connecting to the dataflow through desktop, where the data sources were seperate

    and then aligning the security levels. 

    This allowed for a manual refresh, once I published the pbix, the datalflow no longer showed a refresh error and schedules can be set for both. 

    I note that in the Service, only a single data source is shown,

     which is presumably what caused the initial error, I'm not sure if this is by design or not, but would be interested if anyone else has experienced similar.