Forum Discussion

Ulari's avatar
Ulari
Regular Visitor
1 year ago
Solved

Power Bi REST API update row values in dataset

Hi all,   I have created a dataset via API called Shipment. Each row is one shipment. It is well explained in the MS Learn Center how to add new Rows. But how to update row details? For example I ...
Need Help
Tutorial Requests
  • Jai-Rathinavel's avatar
    Jai-Rathinavel
    1 year ago

    Ulari Updating a row on Power BI dataset is currenlty not possible. Try the recommended approach below

    1. Change your source to an table in a excel file and store the file in sharepoint.

    2. Pull the data from sharepoint into Power BI.

    3. Now with the help of power automate you can update, delete or add rows to the online excel and then refresh the Power BI dataset. 

    https://digitalmill.net/2023/07/24/inserting-and-updating-data-into-excel-tables-with-power-automate/

     

    You can also query the dataset using the Execute Queries connector available in Power Automate and will only be needing power automate free license. 

     

     

     

     

    Did I answer your question ? Please mark this post as a solution.

    Thanks,

    Jai

Expiscornovus's avatar
Expiscornovus
Icon for Most Valuable Professional rankMost Valuable Professional
1 year ago

Hi Ulari,

 

Like you mentioned already, it seems we don't have a updaterows method. It has been listed as an idea for a while though (which you can upvote)

https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=28ebb38e-0b1f-4244-a1ea-ac31996ae3f5&%3B%3B

 

Regarding a workaround, you might be able to use a new column for this (calculated). Can you try a DAX query like the below in your exectureQueries endpoint?

UpdatedCustomerRef = 
IF(Shipments[ShipmentID] = 123, "NewCustomerRefValue", Shipments[CustomerRef])

 

https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-calculated-columns