Forum Discussion
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...
edhans
Community Champion
Community ChampionExcellent. Thanks. Hoping this is a quick fix (days, not weeks/months).
v-juanli-msft
Community Support
Community SupportHi edhans Anonymous
It is informed that the bug will be fixed in the SU2 release with this change:
https://powerbi.visualstudio.com/Power%20Query/_git/power-query/pullrequest/14591
Unfortunately, there's no mitigation at this time, you'd have to essentially run what combine binaries is doing behind the scenes by yourself.
Best Regards
Maggie
- edhans
What does that page say on timing? My github login ID doesn't have authority to access that page. I get a 401 error. "Sorry, but [your account] is not authorized to access this page"
- edhans
FYI - I just tested this and it now appears to work. I have Excel 1902 Insider, but that shouldn't make a difference.