The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hi,
I want to update the Cosmos db transactional database data (some records). What are the ways to do that? can we do it through Power BI desktop or Service?
below are the steps
1. select data from cosmos db
2. Update the record(some fields)
3. check the updated records from power BI.
Thanks
Not directly. Power BI's data write back capabilities are close to non-existent. You can use a PowerApps visual to collect the user update requests and then patch the cosmos db from PowerApps. The cosmos db needs to be accessed in Direct Query mode to get any semblance of an acceptable UX out of this.