Skip to main content

Notifications

Announcements

Join us on April 2nd for the Power Platform AMA - Copilot Studio Edition
🌸 Community Spring Festival 2025 Challenge 🌸
Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id : YVDzYDkXMsg088gUY2dV9B
Power Platform Community / Forums / Power Automate - Power Automate Desktop / Powerbi dataset to pop...
Power Automate - Power Automate Desktop
Suggested answer

Powerbi dataset to populate sharepoint choice column

Like (0) ShareShare
ReportReport
Posted on 28 Mar 2025 10:38:06 by zbeg 291 Super User 2025 Season 1
hi,
 
I have a automatic refreshes powerbi report I need to populate Sharepoint Choice . How do I do that?
Categories:
Process Advisor
  • lbendlin Profile Picture
    lbendlin 7,757 Super User 2025 Season 1 on 29 Mar 2025 at 18:30:29
    Powerbi dataset to populate sharepoint choice column
    1. Run a query against the dataset to fetch all the purchaser IDs. 
    2. Figure out which ones are new
    3. Run SharePoint REST API call (ie a Graph API call) to patch the column.
  • Suggested answer
    Anastasia Profile Picture
    Anastasia 22 on 29 Mar 2025 at 10:28:42
    Powerbi dataset to populate sharepoint choice column
    If you require to get data from a particular visual to work with it further, you can use "Run a query against a dataset" in Power Automate.
    Bellow is a quick and simple demonstration of this functionality.
    How To Copy a Query from Power BI Desktop to Power Automate DAX Query - #Shorts
     
    Resulted JSON can be used in your future steps to populate the Sharepoint list.
     
    Please let me know if more details required.
  • zbeg Profile Picture
    zbeg 291 Super User 2025 Season 1 on 28 Mar 2025 at 12:24:55
    Powerbi dataset to populate sharepoint choice column
     
    powerbi keeps order details incluidng the purchaser id . I have a column with choices . I need to populate the choice column by purchaser id. If any new purchaser comes I need to see it in sharepoint column selection 
     
    :) Thank you for your response
  • Anastasia Profile Picture
    Anastasia 22 on 28 Mar 2025 at 11:32:43
    Powerbi dataset to populate sharepoint choice column
    Hi @zbeg,

    Could you please provide more details of how the PowerBI report and the Sharepoint list (I suppose) are related?
    What is the condition to populate Sharepoint choice?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Join us on April 2nd for the Power Platform AMA - Copilot Studio Edition
🌸 Community Spring Festival 2025 Challenge 🌸
Welcome to the Power Platform Communities

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,513 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,631 Most Valuable Professional

Leaderboard

Featured topics

Flows are not visible for users who sign in with their personal accounts
List of actions cheat sheet for Power Automate Desktop

Product updates

Microsoft Power Platform Community release plans