cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
obespalov Frequent Visitor
Frequent Visitor

Embed dataset via API

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:

Would appreciate any suggestions.

1 ACCEPTED SOLUTION

Accepted Solutions
obespalov Frequent Visitor
Frequent Visitor

Re: Embed dataset via API

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

 

1 REPLY 1
obespalov Frequent Visitor
Frequent Visitor

Re: Embed dataset via API

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