Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Greeting Friends,
i have one technical question.
Current we want to connect our ERP Systeme to Power BI via SQL.
Our IT Department is not sure, if POWER Bi can change the database.
In my opinion this is not possible, because Power BI only get da Query Connection.
Of course via import, or query. But both witout rights to change the database.
Can anyone give information about this?
Many thanks for your answers.
Best Regards pascal
Solved! Go to Solution.
Queries do not have write capabilities, only read.
Hi guys,
It is not documented, but there is such opportunity. See this thread - http://community.powerbi.com/t5/Service/Native-Database-Query-Error/m-p/381860#M41935 . You can write update, truncate, insert and other queries which can change a database via Native Query (advanced option which allows you to enter a query to a database).
Regards,
Ruslan
-------------------------------------------------------------------
Did I answer your question? Mark my post as a solution!
Hi guys,
It is not documented, but there is such opportunity. See this thread - http://community.powerbi.com/t5/Service/Native-Database-Query-Error/m-p/381860#M41935 . You can write update, truncate, insert and other queries which can change a database via Native Query (advanced option which allows you to enter a query to a database).
Regards,
Ruslan
-------------------------------------------------------------------
Did I answer your question? Mark my post as a solution!
Queries do not have write capabilities, only read.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
100 | |
51 | |
19 | |
12 | |
11 |