Forum Discussion

TotalAnonymous's avatar
TotalAnonymous
Helper III
1 year ago
Solved

About XLS file/source

Dear community,  I hope you're doing well. Currently, I'm trying to connect PBI Desktop with the SharePoint folder that contains XLS files.  Here is what I've done using Blank Query ...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi TotalAnonymous,

     

    Thank you for reaching out to Microsoft Fabric Community Forum.

     

    Power BI doesn’t handle XLS files well because they use older drivers that aren’t always supported in Power BI Service. You might get it to work in Power BI Desktop using the CSV function, but there's a high chance it will fail during refresh in the service.

    The best approach is to convert your XLS files to XLSX since Power BI works with them much more smoothly, and your refresh process will be more reliable.

     

    If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!


    Regards,
    Vinay Pabbu

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi TotalAnonymous,

 

Thank you for reaching out to Microsoft Fabric Community Forum.

 

Power BI doesn’t handle XLS files well because they use older drivers that aren’t always supported in Power BI Service. You might get it to work in Power BI Desktop using the CSV function, but there's a high chance it will fail during refresh in the service.

The best approach is to convert your XLS files to XLSX since Power BI works with them much more smoothly, and your refresh process will be more reliable.

 

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!


Regards,
Vinay Pabbu