topic Accessing a dataset via POWER BI REST API or another method? in Developer

Accessing a dataset via POWER BI REST API or another method?

KentKMishra — Mon, 24 Jul 2023 20:31:07 GMT

We've created a PBI dataset for an application to access via the PBI Rest API - but I'm not sure that a great option. We created the PBI dataset so that we could reuse the measures previously created in our SSAS tabular model and make a dataset that is specific to the applications use case.

95% of the PowerBI rest api items I find is directed towards using embedded reports/dashboards. Very little information on accessing a dataset, which has me wondering if it's such a good idea. We are talking millions of rows and I recently ran across a 100K limitation for the PBI Rest API. Is there a better way to do this?

Re: Accessing a dataset via POWER BI REST API or another method?

Anonymous — Wed, 26 Jul 2023 02:53:52 GMT

Hi @KentKMishra,

If these operations are based on rest API, they should also be limited by rest API limitations.

Perhaps you can try to use power bi desktop data connector to getting data from power bi dataset. They should not be effect by these limitations.

Regards,

Xiaoxin Sheng

Re: Accessing a dataset via POWER BI REST API or another method?

KentKMishra — Sat, 29 Jul 2023 00:07:49 GMT

Desktop won't work as it is need for an external application.