Forum Discussion

naelske_cronos's avatar
naelske_cronos
Icon for Advocate II rankAdvocate II
2 years ago

Power BI dataset refresh: use service principal to refresh Sharepoint data with access token

Hello,   I'm trying to refresh a Power BI dataset that has a SharePoint list as datasource, this with the Power BI REST API's via PowerShell and the Power BI modules.   This is the video that I'...
Need Help
soniya-01's avatar
soniya-01
New Member
2 years ago

Problem: Refresh a Power BI dataset with SharePoint data using a service principal and access token.

Solution:

  1. Register App in Azure AD:

    • Create a Power BI app in Azure AD.

  2. Get IDs and Keys:

    • Get App ID, Directory ID, and create a Secret Key.

  3. Permissions:

    • Grant app permissions to access SharePoint.

  4. Power BI Settings:

    • In Power BI, enter app details for service principal.

  5. Access Token Magic:

    • Power BI uses service principal info to get an access token.

  6. Automatic Refresh:

    • Set up automatic refresh in Power BI service.
  • naelske_cronos's avatar
    naelske_cronos
    Icon for Advocate II rankAdvocate II
    2 years ago

    Hello,

     

    I already have an app with everything working but it is not the intention to do this via the UI or Power BI service but programmatically via PowerShell.

     

     

    Kind regards