How can I find all semantic models and paginated reports associated with a given connection?

[dancarr22]

Hello,

How can I find all semantic models and paginated reports associated with a given connection?  i.e. When we go into 'Manage Connections and Gateways' in PBI Service we have all of our connections - mainly to db.  Want to find out what is connected to each connection.  

Thanks,

Dan

[dancarr22]

Thanks @v-kongfanf-msft and @vanessafvg 

[v-kongfanf-msft]

Hi @dancarr22 ,

Thanks for the reply from @vanessafvg , please allow me to provide another insight:

You can use the SQL Server Profiler to monitor and analyze activity on the semantic model. You can use SQL Server Management Studio (SSMS) to script the default Power BI semantic model from the XMLA endpoint.

For Finding Paginated Reports: Paginated reports in Power BI Services can be identified by their specific icons on content lists and home page landing pages.

For more details, you can read below document:

Default Power BI semantic models - Microsoft Fabric | Microsoft Learn

Best Regards,
Adamk Kong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[vanessafvg · Accepted solution]

you  might be able to use the power bi audit data to see this information

examples of api calls

https://learn.microsoft.com/en-us/rest/api/power-bi/groups/get-groups

https://learn.microsoft.com/en-us/power-bi/enterprise/service-admin-auditing

there a variety of ways using powershell, python etc

example

https://pbi-guy.com/2022/03/10/power-bi-and-activity-logs-with-python/