Thank you. In conjunction with my org admins I have created an AppID for access to the partner API's (Not Power BI related... but will be for the data). While my personal account can access the API's we want the AppID to access the API's and do the work for all of the reasons you have stated (someone leaves the organisation etc). I can't access the partner API's with the AppID and I suspect from watching your video that we need to create the EntraID Group and then perhaps grant the EntraID Group access to the partner area.... that might be the bit we're missing. Good video. Thank you.
Excellent video, thank you. The issues we are having seem to be related to the limitations of service principal when using Fabric API. For example, we can run GET .../v1/workspaces/{id}/items/{id} no problem but then trying to list tables in a Lakehouse (GET .../v1/workspaces/{id}/lakehouses/{id}/tables) we get "The operation is not supported for the principal type" message. Do you have any experience with that issue?
This specific issue? No. This type of issue? Yes. When a service principal doesn't directly allow for access, we use the service principal Entea ID group for access. This typically works, but I am not sure it works in every situation.
@@ChrisWagnerDatagod We use the group too, but I think I have identified the reason. Service Principal in not (properly) supported in Fabric API. If you search for idea e5ec086c-f1ce-ee11-92bd-6045bdbce644 (Fabric API - Service Principal Support) in "Fabric Ideas" you will find the relevant information.
I just did it yesterday and used it to authenticate in a Copy Activity in a Data Pipeline from a Sharepoint Online List, but didn't work. Error: invalid credentials 😞 On the Group members, great advice, have to be member not only owner in the Group. 👍
my usecase is that power bi needs to access a restapi with currently a separate token required but that expires so it needs to be resetted manually. Could a service principle be used to do the refresh for the dataset via rest api? Note the restapi can use entra id as identification. I am not sure whether that is possible and if so how to set it up. Any ideas or hints here? Thx and br
@@ChrisWagnerDatagod can you please make a video on how to write / ingest a Json file using android (java) or python to fabric Lakehouse Please Please Please
Thank you. In conjunction with my org admins I have created an AppID for access to the partner API's (Not Power BI related... but will be for the data). While my personal account can access the API's we want the AppID to access the API's and do the work for all of the reasons you have stated (someone leaves the organisation etc). I can't access the partner API's with the AppID and I suspect from watching your video that we need to create the EntraID Group and then perhaps grant the EntraID Group access to the partner area.... that might be the bit we're missing.
Good video. Thank you.
Great video
There you go! Funny how these things fit together.
Excellent video, thank you. The issues we are having seem to be related to the limitations of service principal when using Fabric API. For example, we can run GET .../v1/workspaces/{id}/items/{id} no problem but then trying to list tables in a Lakehouse (GET .../v1/workspaces/{id}/lakehouses/{id}/tables) we get "The operation is not supported for the principal type" message. Do you have any experience with that issue?
This specific issue? No.
This type of issue? Yes.
When a service principal doesn't directly allow for access, we use the service principal Entea ID group for access. This typically works, but I am not sure it works in every situation.
@@ChrisWagnerDatagod We use the group too, but I think I have identified the reason. Service Principal in not (properly) supported in Fabric API. If you search for idea e5ec086c-f1ce-ee11-92bd-6045bdbce644 (Fabric API - Service Principal Support) in "Fabric Ideas" you will find the relevant information.
I just did it yesterday and used it to authenticate in a Copy Activity in a Data Pipeline from a Sharepoint Online List, but didn't work. Error: invalid credentials 😞
On the Group members, great advice, have to be member not only owner in the Group. 👍
my usecase is that power bi needs to access a restapi with currently a separate token required but that expires so it needs to be resetted manually. Could a service principle be used to do the refresh for the dataset via rest api? Note the restapi can use entra id as identification. I am not sure whether that is possible and if so how to set it up. Any ideas or hints here? Thx and br
It's possible that this would work. I would test it on the API to see. I would go 50:50 if this works.
Amazing... Sub , + Like + Comment + Loved....!! 100 % working ...
AWESOME!!!
@@ChrisWagnerDatagod can you please make a video on how to write / ingest a Json file using android (java) or python to fabric Lakehouse
Please
Please
Please
@@syednayyar Putting that on the list!
@@ChrisWagnerDatagod Thank you so much :) I am super pumped cant wait
I am using it to call the fabric on demand pipline execution, but its not working any idea
Does the ID and group have the necessary access? Start with Admin, then lower if possible.