Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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/
Proud to be a Super User!
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.
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/
Proud to be a Super User!