Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
What files can be imported into Power BI?
Solved! Go to 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.
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.
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
User | Count |
---|---|
77 | |
77 | |
68 | |
67 | |
49 |
User | Count |
---|---|
108 | |
105 | |
93 | |
83 | |
64 |