Forum Discussion
end user UI in notebook
Data modification in Power BI (aka "Data Write Back") has been a sore spot for years. Technically you should not write into a downstream system (you should write into the system that feeds Power BI) but there are ways to make that process work seamlessly - for example by first modifying the sematic model (for good UX) and then in the background sync the change with the data source.
As for the notebooks - are you sure you want to expose that part of the process to end users?
No, this is not data that is necessarily subject to return to the source systems. In most cases, this is data that is strictly useful for data analysis. In addition, third-party applications are often used in SaaS mode and it is not possible to add data to the source system.
The idea is to add additional analysis data at the warehouse level to enable rich and dynamic BI solutions.
Similarly, the idea is that the data specialist team can do the work with data world technologies (Python) without needing to have knowledge of C# development for example.