Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Error combining files in Power query from Azure Datalake despite being excel files

I connected my powerbi to our Azure datalake and was able to load the folders into Power Query Editor and choose the excel files I wanted to combine and upload. However, I get an error when I click o...
Need Help
v-juanli-msft's avatar
v-juanli-msft
Community Support
7 years ago

Hi Anonymous edhans

Sorry for inconvenience. 

edhans Thank you for providing such details, it is very generous of you to share.

I have reported this issue, i would come back once i get any information. 

 

Best Regards

Maggie

  • edhans's avatar
    edhans
    Community Champion
    7 years ago

    Any update on this v-juanli-msft from the Azure team?

     

    This is fundamentally broken. The only option is to export all Excel files to CSV, which really isn't ideal at all, especially when there are multiple tables in a single file and you want to combine based on table names within a file.

     

    Downloading and working from local folder isn't an option either, as that 100% defeats the purpose of using Data Lakes to begin with.

    • v-juanli-msft's avatar
      v-juanli-msft
      Community Support
      7 years ago

      Hi edhans

      This issue also reproduced for the engineer.

      They are working on fixing it.

      If there is any update, i will come back to tell you.

       

      Best Regards

      Maggie

      • edhans's avatar
        edhans
        Community Champion
        7 years ago

        Excellent. Thanks. Hoping this is a quick fix (days, not weeks/months).