Forum Discussion
Can we create a template app with Push Dataset?
Hi cte_crest,
I'd like to suggest you use 'power bi service' connect to get data from power bi service, it linked with your power bi account and you can access existing datasets.
If you mean get data from the root URL of power bi datasets, I'd like to suggest you take a look at azure blob storage API. (AFAIK, power bi host its dataset on azure blob storage data source)
Regards,
Xiaoxin Sheng
Anonymous
Thanks for your reply. Actually, I want to push data to the dataset on template apps.
So, let me try to put it in a concise way, about the steps I performed:
- For adding data to powerBI dataset, I want to use Push mechanism through API.
- So, I created some tables in a data set through push api data set and corresponding reports and exported pbix file which I want different users to use as a template app. (I think this is also what will go on the app source when template app will be published.)
- Now, I imported the pbix file, in a new workspace where I get all my reports and data set as well.
- I tried to push data to this data set using powerBI api. That's when I encountered error, indicating that this dataset doesn't support push mechanism.
So, do you think this could be solved? Or am I using it all wrong?
HI cte_crest,
Please double-check on Push datasets REST API limitations, it only allows on push dataset and not works on common datasets that publish form pbix file. Push Datasets
Regards,
Xiaoxin Sheng
Anonymous
Thanks for your information. It makes sense.
I think I was going for an incorrect use case.
I just had another concern. From https://docs.microsoft.com/en-us/power-bi/developer/automation/api-rest-api-limitations?redirectedfrom=MSDN, it seems that the maximum rows allowed in a table for Push Dataset are 5 Million. Is there any reason for it? Is there any way to increase the capacity? At least for premium capacity?
