Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I want to know if there is an alternative to power bi api that creates datasets and binds them to a report. Today, we are using this to clone reports, and datasets and then populate the dataset using post rows. The problem is that there is a limitation for the number of rows to push ( which is 5 million rows ). I want to know if there is a workaround to this limitation, by, maybe, using a datasource (SQl server, or any other source) and import the data from this source to my report (programatically). If not, what do you suggest to automatically bind reports without GUI manipulations ?
Thank you
Hi @Anonymous
Not clear about the requirement.
"we are using this to clone reports, and datasets and then populate the dataset using post rows"
Do you connect to power bi service dataset with Power BI Desktop?
If not, where is the data source from?
@v-juanli-msft Today we are using power bi rest apis, we create the dataset with the api, we clone the template report with the api, we bind the dataset to the report and then we populate it using post rows. The problem of this solution is the 5 Million row limitation. My question is: Is there any way to programatically create reports (maybe using the clone report api) automatically, & bind datasources that use import mode to them?
What I imagine is a similar alternative to the solution we use now, but instead of using post rows (push mode), we use an import mode (from sql server, or csv)
Hi @Anonymous
Sorry, i have no experience about what you describe.
If you'd like to copy the dataset and report of a Power BI Desktop file, then reuse it, you may upload them to a Power BI App workplace where you can publish an app, with an app, anyone who can get this app can make a copy of it and resue the dataset and report of the app.
https://docs.microsoft.com/en-us/power-bi/consumer/end-user-apps
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.