Forum Discussion

arvydas92's avatar
arvydas92
Regular Visitor
5 years ago

Strict open xml spreadsheet with Power BI

Hello,

 

I am unable to open strict open xml spreadsheet file with a Power BI. If the same file is saved as normal xmlx then everything works fine.

Unfortuantelly I cannot change the format or replace the file with a new one. 

Error I am getting below:

 

 

Thanks!

Need Help

9 Replies

  • v-yingjl's avatar
    v-yingjl
    Community Support
    5 years ago

    Hi arvydas92 ,

    Sorry for replying late. You should know that .xml file and .xmlx file is not the same format.

    A .xml file format should be like this and power bi can identify it by using xml connector

    <note>
<to>Tove</to>
<from>Jani</from>
<heading>Reminder</heading>
<body>Don't forget me this weekend!</body>
</note>

     

    A .xmlx file is Excel spreadsheet, this .xmlx file type entry was marked as obsolete and no longer supported file format.

    If the spreadsheet is like this:

    Power bi will identify it as a .csv file, xml connector could not open this in power bi.

     

     

    Best Regards,
    Yingjie Li

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

     

    • arvydas92's avatar
      arvydas92
      Regular Visitor
      5 years ago

      Hi, v-yingjl 

       

      Thanks for the info.

       

      Just to clarify. It is shown as xlsx format:

       

       

      • v-yingjl's avatar
        v-yingjl
        Community Support
        5 years ago

        Hi arvydas92 ,

        Since the format is .xlsx file, you can use Excel connector in power bi to open it directly. 

         

        Best Regards,
        Yingjie Li

        If this post helps then please consider Accept it as the solution to help the other members find it more quickly.