Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
What files can be imported into Power BI?
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 |
---|---|
98 | |
91 | |
84 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |