Forum Discussion
Integration with web app
Thank you for the comment
You are right, I have access to the database as well. However, I'm not sure about option one, as don't want shared data for the users. I could go with the API or REST API method though.
Should it be possible for me to handle the scenario described though - to provide both report and data to the account of the users?
I have some more thoughts regarding this.
I thought I came to the conclusion that what I wanted to achieve would actually be possible in a quite simple way, but then I got some problems while testing...
My idea was that I should be able to import (though the API or manually) pre-made reports to Power BI account, then just update the tables of the datasets for them through the REST API. However, it seems that datasets handled by the Power BI Desktop are not possible to update through the REST API. I get an error with the following message:
Posting rows to this type of dataset is not currently supported. Please create your dataset by posting it through the API following the instructions on http://dev.powerbi.com".
It's not really an option for me to create the reports within the Power BI web app as it's too limited and as I want to have computed fields for the datasets. I can't find any information how that would be possible to do through the API.
If my thoughts here seem right, please let me know what other approach I could take.