CODEWITHSUNDEEP
sqlpowerbi
Máté Juhász
Máté Juhász

Reputation: 2327

Alter data source

Power BI can connect to various data sources and run SELECT queries.

Is it possible to run also other queries (INSERT INTO, UPDATE...)?

Now I need it for a postgresql database, but could use also for others in the future.

Upvotes: 0

Views: 62

Answers (2)

Andrey Nikolov
Andrey Nikolov

Reputation: 13440

No, you can't run directly INSERT/UPDATE queries from Power BI. This isn't the idea of the tool. If you find you need it, then probably there is a major flaw in your design, or you are not using the right tool for this job. But there are few ways to workaround this (again, I'm not saying that you SHOULD do it). Usually this is done in a combination with custom written Power App, embedded in your report in Power Apps visual. The idea is that the app will write to the database, and will refresh your report after that (if needed).

You can start here and I will recommend you to look at this in-depth session - Writing back data to PowerBI from your reports.

Upvotes: 2

mkRabbani
mkRabbani

Reputation: 16908

The answer is No if I am very straight forward. PBI is a analysis platform for data. There are probably some advance way to do that but, this is not logical or good idea to think about manipulating data from report or from any BI tools. You can search answers from different blog where the same questions asked. For more details, you can check below links-

  1. help link 1
  2. help link 2

Upvotes: 1

Related Questions