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

Ulari's avatar
Ulari
Regular Visitor
1 year ago

Hi Expiscornovus 

 

Thanks for replying!

May I use your kind help a little further?

 

I am struggeling with implementing the request body.

Can you point me to correct direction?

And even further - would it be possible to over-write the original value instead adding new column? This customer ref field was just an example. Basically any field may change.

 

Thanks

Ülari

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi Ulari ,

     

    As far as I know, Power BI is a read-only application to create report and analysis data. Power BI currently support us to execute dax queries for dataset by REST API.

    Datasets - Execute Queries - REST API (Power BI Power BI REST APIs) | Microsoft Learn

    Your new requirement sounds like replace function. You can try replace in Power Query Editor in Power BI Desktop.

    It doesn't support us to call it by REST API.

    Replace 123's original CustomerRef A to NewCustomerRef 

     

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.