- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
How to create a dataset from multiple excel files (located on different SharePoint - Team Sites)?
Hi,
With Power BI Desktop, we can create a dataset which connects to multiple excel files.
From Power BI Service, New -> Dataset, then click 'Get' button on the Files pane, input URL for SharePoint - Team Sites, navigate to the subfolders, I can select only one Excel file. A dataset with the same name (to the selected Excel file) would be created after the process, and I cannot find a way to add more Excel files to it.
I would like to create a dataset which connects to multiple excel files located on different SharePoint - Team Sites with Power BI Service. Can anyone help on this?
Thank You!
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @acan107 ,
In Power BI Desktop, you could create a dataset that connects to multiple excel files
In Power BI Service, you could only create a dataset with one sharepoint sites.
But you could create a dataflow with multiple excel files in sharepoint firstly, then create a dataset with this dataflow.
For more details, you can read related document: Introduction to dataflows and self-service data prep - Power BI | Microsoft Learn
Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @acan107 ,
In Power BI Desktop, you could create a dataset that connects to multiple excel files
In Power BI Service, you could only create a dataset with one sharepoint sites.
But you could create a dataflow with multiple excel files in sharepoint firstly, then create a dataset with this dataflow.
For more details, you can read related document: Introduction to dataflows and self-service data prep - Power BI | Microsoft Learn
Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Microsoft Fabric Community Conference 2025
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
Subject | Author | Posted | |
---|---|---|---|
06-28-2024 06:51 AM | |||
06-12-2024 06:45 AM | |||
08-01-2024 06:54 AM | |||
05-22-2024 06:59 AM | |||
12-16-2018 12:53 AM |
User | Count |
---|---|
25 | |
24 | |
13 | |
10 | |
10 |
User | Count |
---|---|
48 | |
41 | |
24 | |
16 | |
15 |