Forum Discussion
DMV Queries Against a Power BI Dataset Using ADF
You could look at using the API Scanner which will have almost all the information you are looking for.
If you want something more specific it can be done with functions in Power Query to loop through the data and put it into a dataset.
I typically would advise to use the likes of PowerShell to extract the data you need into Azure Blob storage so that you have always got the source files saved. Then create a dataset off the files in Azure Blob Storage.
You could look at using the API Scanner which will have almost all the information you are looking for.
If you want something more specific it can be done with functions in Power Query to loop through the data and put it into a dataset.
I typically would advise to use the likes of PowerShell to extract the data you need into Azure Blob storage so that you have always got the source files saved. Then create a dataset off the files in Azure Blob Storage.
Hi GilbertQ Thank you for replying. After I posted the comment about APIs I did some Googling and found this. Everything is there.