Forum Discussion

sraja123's avatar
sraja123
New Member
25 days ago

Power BI Admin API parameters

Hello, We need to use the https://learn.microsoft.com/en-us/rest/api/power-bi/admin/reports-get-report-subscriptions-as-admin API to get access to subscriptions data for the PBI paginated reports. W...
Need Help
sraja123's avatar
sraja123
New Member
25 days ago

Thanks for the reply. Can you please clarify :

 

  1. XMLA / TOM endpoint — If your paginated reports are in a Premium/Fabric workspace, you can query the XMLA endpoint for report metadata, but this still won't give you per-subscription parameter values. For this- I think what you meant is if a report subscription has parameters , this will not give us what values are passed in each subscription correct?
  2. For #4 - where is the report parameters stored?
  3. for the last one - Manual export + parsing — "Some teams export subscription configs from the Power BI service UI and parse them, but this doesn't scale"- can you provide more informaiton on which UI to be called? Is it available as a API that we can call using Alteryx and parse them?

Thank you again!

audreygerred's avatar
audreygerred
Super User
25 days ago

Unfortunately none are good, reliable, or efficient solutions. I should have really left 1-4 of because they can't really be accessed. For #5, I have never done it myself but have heard of teams trying to do this:

  1. Manage Subscriptions page — As a Power BI admin, you can go to the Admin Portal → Subscriptions, which gives you a list view of subscriptions across the tenant. This is UI-only though, there's no export button natively.
  2. Per-report subscription view — Opening a paginated report and going to Subscriptions shows you each subscription with its parameters configured. Again, UI only.
  3. Browser DevTools network capture — This is where the "parsing" part comes in. When you load the subscriptions management page, Power BI makes background API calls to retrieve the subscription data. You can:
    • Open Chrome DevTools → Network tab
    • Navigate to the subscriptions page for a report
    • Intercept the raw API response which often contains more fields than the documented public API returns, sometimes including parameter values
    • Copy that JSON payload out manually

      You can also go to the submit ideas page and look for ideas that you can vote on in hopes of Msft shipping them to prod, and or add your own: Fabric Ideas - Microsoft Fabric Community