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 have 2 servers/databses combined in one report like visualized below.
As shown i have semantic models in the middle due to domain issues. In the semantic layer 2 one of the sources is a composite model (import and direct query) whereas ther other is only import.
Question:
Hi @AbiNyk
Synchronization of Layers:
Automating Refresh with Power Automate:
Change Detection in Layer 1:
Best Practices:
By automating refreshes and using change detection where applicable, you can ensure data consistency and up-to-date reports across all layers.
Did I answer your question? Mark my post as a solution, this will help others!
If my response(s) assisted you in any way, don't forget to drop me a "Kudos" 🙂
Kind Regards,
Poojara
Data Analyst | MSBI Developer | Power BI Consultant
YouTube: https://youtube.com/@biconcepts?si=04iw9SYI2HN80HKS
Thank you for the answer and effort(!). However I am not sure whether layer 2 and 3 synchronize what best practice is...