Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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 Sha...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Anonymous ,

    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.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Anonymous ,

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.