Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hi community,
Just wondering if anyone else is experiencing the same issue with Power BI REST API the Datasets - Get Dataset To Dataflows Links In Group call.
When I ran the API call using the Try It button (my personal token) and also in Power Query, it returned all the data (559 rows), however, when I ran it with the Service Principal token in Power Query, it only returned a small subset of the data (36 rows).
Solved! Go to Solution.
Update (25 September):
Looks like the issue has been resolved by itself. Service Principal calls are returning all data now.
Update (25 September):
Looks like the issue has been resolved by itself. Service Principal calls are returning all data now.
Hi @Jay_Geng ,
If I understand correctly, it seems that it can't return the entire data, only return part of data when call REST API Datasets - Get Dataset To Dataflows Links In Group. The problem could be due to the permissions associated with the Service Principal. The Service Principal will have access to the data only if it has authorization on that workspace. Please ensure that the Service Principal has the necessary permissions (Dataset.ReadWrite.All or Dataset.Read.All) to access all the data.
Best Regards
Hi Yiruan,
Thank you for your reply.
I can confirm that the Service Principal has the required API permission as shown in the screenshot, and the Service Principal also has admin access to all of the workspaces.
I believe this issue only started to occur recently. Before, I was using the exact same method with the same Service Principal and I was able to pull all the data.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
4 | |
3 | |
3 | |
3 | |
3 |