This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. We're covering it all. You won't want to miss it.
Learn moreDid you hear? There's a new SQL AI Developer certification (DP-800). Start preparing now and be one of the first to get certified. Register now
Hi,
I am not able to find any info to get data from dataset using REST API from dataset.
Is it possible to get extract data from dataset using REST API?
Thanks,
Pritam
Unfortuantely the row count limit still applies. found below article on how to use pagination using DAX queries.
Execute Query endpoint - Get your data from datasets
Hi @Anonymous ,
Take a look at the overview on the dataset rest api, hopefully it has what you want:
Datasets - REST API (Power BI Power BI REST APIs) | Microsoft Docs
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
Thanks for Reply,
The link which you have provided there is limitation of 100000 rows for provided API. Is there any rest API where we can extract all data from our dataset.
Thanks,
Pritam
Check out the April 2026 Power BI update to learn about new features.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.