Semantic Data Model Activity Logs?

[Ipsifendus]

We have a semantic data model published to PowerBI.com, and an Excel workbook with a pivot table connected to that data model. I'm able to interact with the pivot table without issue, as is one of my coworkers. I have another coworker, however, who is getting an error whenever he attempts to use it:

"COM error: COM error: Microsoft.AnalysisServices.AzureClient, An error occurred while sending the request.." [punctuation as given]

We're looking at the configuration of his PC and his user account, but one thing that I haven't been able to figure out is how to scrutinize the history of people connecting to the data model and interacting with it. The associated PowerBI report, of course has a usage metrics report, but the model itself doesn't seem to have any obvious pathway to accessing usage history.

[nilendraFabric · Accepted solution]

Hello @Ipsifendus 

The Power BI Activity Log API allows you to track various activities across your tenant, including dataset interactions. While not specific to semantic models, it can help identify user actions related to datasets and reports
https://sqlserverbi.blog/2020/01/06/getting-started-with-the-new-power-bi-activity-log

If you are using Microsoft Fabric, you can analyze semantic model logs using KQL queries. This approach provides granular details such as executing users, application names, dataset IDs, and session counts

If your WS is premium 

Power BI Premium workspaces provide access to semantic model operation logs through the Eventhouse KQL database. These logs capture events such as query execution, partition processing, and user interactions.

if this is helpful please gives kudos and accept the answer 

[v-prasare]

@Ipsifendus As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by our community members for your issue worked? or let us know if you need any further assistance here?

Thanks,

Prashanth Are

MS Fabric community support

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query

[v-prasare]

@Ipsifendus, As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by our community members for your issue worked? or let us know if you need any further assistance here?

Thanks,

Prashanth Are

MS Fabric community support

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query

[v-prasare]

@Ipsifendus, As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by our community members for your issue worked? or let us know if you need any further assistance here?

@GilbertQ, @nilendraFabric Thanks for your promt response

Thanks,

Prashanth Are

MS Fabric community support

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query

[GilbertQ · Accepted solution]

Hi @Ipsifendus 

Could you check the version of Excel that the user is running that is causing the issue and compare it to your version of Excel? My assumption is that they are running an older version of Excel, which means their client libraries that connect to the semantic model are older and that is why it is causing this com error.

[nilendraFabric · Accepted solution]

Hello @Ipsifendus 

The Power BI Activity Log API allows you to track various activities across your tenant, including dataset interactions. While not specific to semantic models, it can help identify user actions related to datasets and reports
https://sqlserverbi.blog/2020/01/06/getting-started-with-the-new-power-bi-activity-log

If you are using Microsoft Fabric, you can analyze semantic model logs using KQL queries. This approach provides granular details such as executing users, application names, dataset IDs, and session counts

If your WS is premium 

Power BI Premium workspaces provide access to semantic model operation logs through the Eventhouse KQL database. These logs capture events such as query execution, partition processing, and user interactions.

if this is helpful please gives kudos and accept the answer