Updating tables directly in Power BI

[Anonymous]

Just curious...is there a way in Power BI to make changes to the content of tables (directy in Power) that were pulled in from Excel databases.  It would be nice if I could update or correct an Excel linked table in Power BI versus having to open up the Excel spreadsheet, make the change, refresh and then republish.  Can this be done or perhaps an option down the road?

[DoubleJ]

This is not possible. Imho this makes sense as an update of the underlying Excel table would override the manually edited values in Power BI desktop again.

It is possible though to manually copy your data from your Excel spreadsheet and paste it into an in-app table in Power BI Desktop.

Hope this helps

JJ

[Anonymous]

Hi there, 

How can you paste the excel data directly into PBI? I haven't been able to figure that out. I have a table imported from excel, and I'd like to paste updated data over the current data. Thanks!

[parry2k]

Hey @Anonymous

Yes, it is possible that you can push data directly to powerbi dataset but you need to create your dataset using PowerBI Rest API or create Strearming dataset, once it is create thru Rest API or Strearming, you can use microsoft flow to push data to dataset.

Basically the answer to you question is that it is possible but there is work involved in it.

Let me know if you are interested to know more about this.

Cheers,

P

[Anonymous]

Yes...I am defiantely interested in learning how!  I would use this option quite a bit.

[parry2k]

No problem, here are some interesting links to get started.

https://msdn.microsoft.com/en-us/library/mt147898.aspx

here is the link which talked about how to insert data using microsoft flow and rest api

https://community.powerbi.com/t5/Community-Blog/Inserting-data-into-a-PowerBI-Dataset-via-Flow-and-t...

Good luck and if you need more help, please let me know.

Thanks,

Parv

[parry2k]

One quick think, your question belongs to developer forum thou, just for reference

https://community.powerbi.com/t5/Developer/bd-p/Developer

[Anonymous]

Thanks...I did not know.

[v-sihou-msft]

@Anonymous

Power BI is a reporting tool. Even using Streaming Dataset, it is just rendering live data directly. You still can't update table within Power BI and sync your changes back to your data source. You can only update the data in your source table.

Regards,