Combining xlsx Files

[OliBen]

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...? 

[v-stephen-msft · Accepted solution]

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.           

[Jcrawford01]

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.