Forum Discussion
Integration with web app
gusly What I understood from your given requirement and my suggestions:
1. If you have your own web app then you would be having database as well which will store data. If this database is a standard database supported by Power BI Desktop Tool, you can easliy import and schdule for data refresh.
2. If you have an API, then you could pull data coming from web app into a standard SQL database and then connect with Power BI Desktop and thereafter reports/dashbaords. Here you need to schedule refresh for API (from web app to API) and Database (Database to Power BI) both.
3. Also you can directly connect you web app to Power BI Service using REST API. Here no need to schedule data refresh. Data will automatically update and refresh once it hits your 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.
