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 wanted to follow up...not everything was there. Specifically, relationships and calculation groups/items are not included in the output from the API call. Those things are critical for documentation so back to the drawing board. But thank you again!