Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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:
Upload the .xls file to a cloud storage service such as OneDrive, SharePoint, or Azure Blob Storage.
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.
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.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
16 | |
2 | |
1 | |
1 | |
1 |