Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Jay_Geng
Frequent Visitor

Power BI REST API [Datasets - Get Dataset To Dataflows Links In Group] Not Pulling All Data

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

 

1 ACCEPTED SOLUTION
Jay_Geng
Frequent Visitor

Update (25 September):

 

Looks like the issue has been resolved by itself. Service Principal calls are returning all data now.

View solution in original post

3 REPLIES 3
Jay_Geng
Frequent Visitor

Update (25 September):

 

Looks like the issue has been resolved by itself. Service Principal calls are returning all data now.

v-yiruan-msft
Community Support
Community Support

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.

vyiruanmsft_0-1695196829748.png

Best Regards

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

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.

 

Jay_Geng_0-1695197213437.png

 

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.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.