Forum Discussion

Toi69___'s avatar
Toi69___
Frequent Visitor
1 year ago
Solved

how to get data about users from powerbi rest api without been administrator

Hello all, I looking for a solution to get evant activity ou audit log from power bi rest api or azure. I created a application on azure, a service principal and a secret. A have thoses permissi...
Tutorial Requests
  • Toi69___'s avatar
    Toi69___
    1 year ago

    Thank you for this overview.
    I still have a question when you say :

    "Set up a separate service principal account with the required role and permissions, and use that identity for your API calls."

    I do not understand beacause when a make ma api call, i use my service principal informations to get data.


    Here this is my python witch give me the token :

    import msal
    import requests
    import pandas as pd

    # === Paramètres ===
    TENANT_ID = 'my tenant id'
    CLIENT_ID = 'my client id of my enterprise application'
    CLIENT_SECRET = 'My secret '

    # === Authentification ===
    def get_graph_access_token():
        app = msal.ConfidentialClientApplication(
            client_id=CLIENT_ID,
            authority=f"https://login.microsoftonline.com/{TENANT_ID}",
            client_credential=CLIENT_SECRET
        )
        result = app.acquire_token_for_client(scopes=GRAPH_SCOPE)
        if "access_token" in result:
            return result['access_token']
        else:
            raise Exception(f"Échec de l'authentification : {result}")

    # === Script principal ===
    if __name__ == "__main__":
        token = get_graph_access_token()

    With this a can get data for microsoft graph api in is v1.0 version but for the auditlog i need to use the beta version and at this time i receive a error.

    So if i understand i receive a token witch is connecting to my service principal so in this case a should not have error of permissions ?

    Do i understand correct ?
    If not coult you give me the solution to use my service principal correcty ?

    Thank you Poojara_D12 
  • v-lgarikapat's avatar
    v-lgarikapat
    1 year ago

    HI Toi69___ ,

     

    I have included the previously resolved thread and learning documents. They may help you resolve the issue

    We truly appreciate your continued engagement and thank you for being an active and valued member of the community.

    If you're still experiencing any challenges, please don’t hesitate to reach out  we’d be more than happy to assist you further.

    We look forward to hearing from you.

    Best regards,
    Lakshmi

    Solved: Re: Extracting power BI Usage logs without powerBI... - Microsoft Fabric Community

    Microsoft Graph permissions reference - Microsoft Graph | Microsoft Learn

     

v-lgarikapat's avatar
v-lgarikapat
Icon for Community Support rankCommunity Support
1 year ago

Hi Toi69___ ,

Thanks for reaching out to the Microsoft fabric community forum.

rohit1991 , Poojara_D12 , lbendlin  

Thanks for your prompt response

Toi69___ 

I wanted to follow up and confirm whether you’ve had the opportunity to review the information  provided super users . Should you have any questions or require further clarification, please don't hesitate to reach out.

 

We appreciate your engagement and thank you for being an active part of the community.

Best Regards,

Lakshmi Narayana

  • v-lgarikapat's avatar
    v-lgarikapat
    Icon for Community Support rankCommunity Support
    1 year ago

    Hi Toi69___ ,

     

    If your question has been answered, we kindly encourage you to mark the most helpful response — such as those provided by @rohit1991, @Poojara_D12, or @lbendlin  as the Accepted Solution.
    Doing so helps other community members facing similar issues to find answers more easily.

    We truly appreciate your engagement and support.

    Best regards,
    LakshmiNarayana

    • v-lgarikapat's avatar
      v-lgarikapat
      Icon for Community Support rankCommunity Support
      1 year ago

      Hi Toi69___ ,

      If your question has been answered, we kindly encourage you to mark the most helpful response  such as those provided by @rohit1991, @Poojara_D12, or @lbendlin  as the Accepted Solution.
      Doing so helps other community members facing similar issues to find answers more easily.

      We truly appreciate your engagement and support.

      Best regards,
      LakshmiNarayana