https://community.fabric.microsoft.com/t5/Developer/Activity-log-for-DirectQuery-to-Power-BI-Datasets-composite/m-p/3115861#M41596 <P>If user adds Excel data to the parent Power BI Dataset, it creates a second, chained Power BI Dataset that has two connections. In this composite model you have one DirectQuery to the parent model and a connection to Excel. Whenever user perform actions on this new, chained Power BI Dataset and the report built on top, log activity points towards the chained dataset only. Therefore, usage on the parent dataset looks low. How can we track actual usage of the single parent dataset by including all the queries from the many chained datasets with their DirectQuery connections to it?</P> Tue, 07 Mar 2023 09:19:38 GMT mmossel 2023-03-07T09:19:38Z https://community.fabric.microsoft.com/t5/Developer/Activity-log-for-DirectQuery-to-Power-BI-Datasets-composite/m-p/3115861#M41596 <P>If user adds Excel data to the parent Power BI Dataset, it creates a second, chained Power BI Dataset that has two connections. In this composite model you have one DirectQuery to the parent model and a connection to Excel. Whenever user perform actions on this new, chained Power BI Dataset and the report built on top, log activity points towards the chained dataset only. Therefore, usage on the parent dataset looks low. How can we track actual usage of the single parent dataset by including all the queries from the many chained datasets with their DirectQuery connections to it?</P> Tue, 07 Mar 2023 09:19:38 GMT https://community.fabric.microsoft.com/t5/Developer/Activity-log-for-DirectQuery-to-Power-BI-Datasets-composite/m-p/3115861#M41596 mmossel 2023-03-07T09:19:38Z https://community.fabric.microsoft.com/t5/Developer/Activity-log-for-DirectQuery-to-Power-BI-Datasets-composite/m-p/3758549#M50357 <P>I have the same question.</P> Tue, 12 Mar 2024 16:23:10 GMT https://community.fabric.microsoft.com/t5/Developer/Activity-log-for-DirectQuery-to-Power-BI-Datasets-composite/m-p/3758549#M50357 MarijnS 2024-03-12T16:23:10Z