Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Regular Visitor

PBI Embedd create dataset and report

Hi All,


I'm busy creating a solution that requires me to upload a .xls file to create a dataset and then create a report using the uploaded dataset. Does anyone know if I can do this using the JS embed option or I need something else?


Thanks in advance

Super User
Super User

To upload a .xls file and create a dataset and report using Power BI Embedded, you would typically use the Power BI REST API. Here is the basic process:

  1. Upload the .xls file to a cloud storage service such as OneDrive, SharePoint, or Azure Blob Storage.

  2. Use the Power BI REST API to create a dataset from the uploaded file. You'll need to specify the data source type (e.g. "excel"), the file location, and the credentials for accessing the file.

  3. Once the dataset is created, use the Power BI REST API to create a report based on the dataset. You'll need to specify the dataset ID and any desired report properties such as the theme, visualizations, and layout.

  4. To embed the report in a web application, you'll use the Power BI JavaScript API. This API provides a way to programmatically interact with the report, including retrieving and displaying the report content in an iframe.

You can find more information about the Power BI REST API and the Power BI JavaScript API in the Power BI Developer Documentation:

I hope this helps!

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.