Beginner level PowerBI/SQL person here
I have my Insights setup and performing ETLs fine. Have tested the sample reports provided for both PowerBI and Tableau and I think I am ready to attempt to start editing the queries/tables to tailor them to our environment.
Question: If I make a table change, will it be overwritten by the next replication of BFEnterprise onto BFInsights db. I currently have replication running nightly.
For example: The Device Inventory visualization for Device Count by OS. I have filtered that down to Windows OS only. The way the query is written, it then lists each sub-version of Win10/2019 as a separate pie chunk(1607/1809/1903). I would like to have a single pie piece for 2019 and 1 for Win10. I think I can do that by merging the data fields in the db, but will it be overwritten nightly? Is there a better way?
Also, can we add a “Insights” group to this forum, since it is another app now?