Forum Discussion
Power Bi REST API update row values in dataset
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.
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
Super UserUlari 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.
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
Thanks you! This is exactly what I needed to understand. I am disappointed of course that there is now way of updateing the rows directly in Power BI but good at least that I did get the confirmation.
My only concern now is that I will be running out of lines in Excel spreadsheet (Max 1M lines) over time and need to set up a logic to add new files when this happens.
Will look into this setup anyways - thanks once more!
- Jai-Rathinavel
Ulari You can use dataverse table instead of a excel table but you would be required to purchase premium license. You can use the update row / add row connector for dataverse within the power automate flow. Dataverse tables support direct query too !
Did I answer question ? Please mark this post as a solution.
Thanks,
Jai
Hello Jai-Rathinavel again
Thank you for this hint. I will give it a closer look.