Embed dataset via API

[obespalov]

I need programatically import user-provided csv to Power BI and send direct link to imported data to user's email.

This is app-owns-data scenario and user is not registered in Power BI service so as I understand this is possible via embedded tools.

I managed to create dataset and add all rows to it from CSV via API but can't find any way to provide result to the user without manual operations.

Ideas I investigated:

• create Report from Dataset and embed Report
  REST API doesn't seem to have any report creation endpoints (https://docs.microsoft.com/en-us/rest/api/power-bi/reports)
• create Dashboard, add Dataset to it and embed Dashboard
  no endpoints to add anything to dashboard (https://docs.microsoft.com/en-us/rest/api/power-bi/dashboards)

Would appreciate any suggestions.

[obespalov · Accepted solution]

Solved it by embedding dataset as Q&A with

Mode: ResultOnly (Show answer only, use predefined question)

Question: "default"

Related APIs:

https://docs.microsoft.com/en-us/rest/api/power-bi/embedtoken/datasets_generatetokeningroup

URL to embed: https://app.powerbi.com/qnaEmbed as found in playground.

It can be tested in playground: https://microsoft.github.io/PowerBI-JavaScript/demo/v2-demo/index.html