PaaS services dashboard

[jmservera]

Is there any plan to create a PaaS services dashboard similar to the IaaS one? It would be very useful to get information about the different plans used for AppService and Functions, information about the different managed databases, and so on.
If there are no plans, how can I get some guidance about how to create it? I.e.: do I need to modify the custom connector or can I create new queries directly?

[jmservera]

I investigated a little bit; I saw that there's no need to modify the connector and I can create my own queries to the REST Api, so I will try to do a PoC for the PaaS Services. For example, I can add something like this to get a list of the server farms (I know there's still work to do to prepare the columns):

// ListServerFarms
let ListServerFarms = (SubscriptionId as text) =>
let
 GetPages = (Path)=>
 let
     Source = Json.Document(Web.Contents(Path)),
     LL= @Source[value],
     result = try @LL & @GetPages(Source[#"nextLink"]) otherwise @LL
 in
 result,
    Fullset = GetPages(GetManagementURL(AzureKind)&"/subscriptions/"&SubscriptionId&"/providers/Microsoft.Web/serverfarms?api-version=2019-08-01"),
    #"Converted to Table" = Table.FromList(Fullset, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
    #"Expanded Column1" = Table.ExpandRecordColumn(#"Converted to Table", "Column1", {"id", "name", "type", "kind", "location", "tags", "properties", "sku"}, {"id", "name", "type", "kind", "location", "tags", "properties", "sku"})
 in
    #"Expanded Column1"
 in
    ListServerFarms

// ServerFarms
let
    Source = #"All Subscriptions",
    #"Invoked Custom Function" = Table.AddColumn(#"All Subscriptions", "ListServerFarms", each ListServerFarms([subscriptionId])),
    #"Removed Errors" = Table.RemoveRowsWithErrors(#"Invoked Custom Function", {"ListServerFarms"}),
    #"Expanded ListServerFarms" = Table.ExpandTableColumn(#"Removed Errors", "ListServerFarms",{"id", "name", "type", "kind", "location", "tags", "properties", "sku"}, {"id", "name", "type", "kind", "location", "tags", "properties", "sku"})
in
  #"Expanded ListServerFarms"

So, this will take a while, but it looks like it can be done. But I still need some guidance on how you are structuring this project:

• queries: I've seen you are exporting all the queries into an .m file, but all these queries are already inside the pbix file. So I assume you are doing this to document the query changes and have history, right?
• PBIX: Should I create a new PaaS pbix or would it be better to add a new tab for PaaS & FaaS?
• Data services: if I create a separate PaaS pbix, is it ok to add there the databases?

Thanks,
Juanma