Forum Discussion
Combining xlsx Files
Hi there,
I am currently experiencing a issue with combining SharePoint files in Power Bi.
It seems that Power Bi does not recognize the official Excel Workbook xlsx format anylonger (CSV does work however).
Mysteriously combining the same xlsx files is possible via the local drive.
Would you happen to have any solution around this issue...?
Hi OliBen ,
Here's the workaround to it, please kindly refer to
Workaround to the problem in the dataflow – “We di... - Microsoft Power BI Community
Try to combine the attachment files in the on-premises Power Query Editor first, then copy and paste the combined query into the dataflow.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
I am following as I am receiving a similar error. My old queries that do the same function appear to work correctly and data refreshes but if I write a new Query it won't move past the combine button selection.
Hi OliBen ,
Here's the workaround to it, please kindly refer to
Workaround to the problem in the dataflow – “We di... - Microsoft Power BI Community
Try to combine the attachment files in the on-premises Power Query Editor first, then copy and paste the combined query into the dataflow.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
