What files can be imported into Power BI?

[Syndicate_Admin]

What files can be imported into Power BI?

[Anonymous · Accepted solution]

Hi @Syndicate_Admin ,

Your solution is great, @TomMartens . It worked like a charm! Here I have another idea in mind, and I would like to share it for reference.

Power BI supports a wide range of file types for importing data. Such as Excel (.xlsx, .xlsm), Text/CSV (.txt, .csv), XML files, JSON files, Folder , PDF files, Parquet files, SharePoint folder, Power BI Desktop (.pbix).

You can read this document for a further study: Data sources in Power BI Desktop - Power BI | Microsoft Learn

Best Regards

Yilong Zhou

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

[TomMartens]

Hey @Syndicate_Admin , KarWar,

here you will find all data sources, including file types like Excel that can connect to using Power Query to import data: List of all Power Query connectors - Power Query | Microsoft Learn

Hopefully, this is what you are looking for.

Regards,

Tom