Forum Discussion

OliBen's avatar
OliBen
New Member
3 years ago
Solved

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...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    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.           

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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.