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
Icon for Community Support rankCommunity 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
Icon for Community Champion rankCommunity 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.