Programatic Import from Sql server database

[Anonymous]

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

[v-juanli-msft]

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?

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

@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)

[v-juanli-msft]

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

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.