Embed dataset via API

obespalov — Mon, 27 May 2019 18:27:42 GMT

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.

Re: Embed dataset via API

obespalov — Tue, 28 May 2019 19:14:31 GMT

Solved it by embedding dataset as Q&A with

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

Question: "default"

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