Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
odnufm
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

1 REPLY 1
jaweher899
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: https://docs.microsoft.com/en-us/power-bi/developer/

I hope this helps!

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.