Forum Discussion

Scott_Powell's avatar
Scott_Powell
Icon for Helper V rankHelper V
3 years ago
Solved

Can Dataflow Gen2 read from lakehouse "Files" as a folder?

Hi, I've uploaded several hundred daily Power BI audit logs into a Lakehouse under the Files area. I'd like to use a Dataflow Gen2 to combine the files and then reshape them. Is there a way to do thi...
Dataflows
Need Help
  • yjh's avatar
    yjh
    3 years ago

    =Lakehouse.Content（null）

    Then Drill down.

    sorry for my poor English.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi yjh I realize I wasn't clear at all. I'm not trying to load them into Power BI desktop, I'm trying to use a Dataflow Gen2 to load them into tables in the Lakehouse.

 

Thanks,

Scott

  • yjh's avatar
    yjh
    Icon for Helper II rankHelper II
    3 years ago

    The method is the same.

  • yjh's avatar
    yjh
    Icon for Helper II rankHelper II
    3 years ago

    =Lakehouse.Content（null）

    Then Drill down.

    sorry for my poor English.

    • joeguicearnold's avatar
      joeguicearnold
      Icon for Advocate I rankAdvocate I
      2 years ago

      This does not work for multiple files in the same folder though, right?  You can only select a single file using this method as far as I an tell.

      • miguel's avatar
        miguel
        Icon for Community Admin rankCommunity Admin
        2 years ago

        You can use the combine files experience the same as with other file system views (SharePoint, data lake, folder and others). If you're seeing any issues with this approach please create a separate topic / thread so we can take a closer look at it