Forum Discussion
Solved
DMV Queries Against a Power BI Dataset Using ADF
Hi! I have an situation I could use some help with.
Because we haven't been able to get either Alation or Purview to work properly end-to-end (complete documentation from source to Power BI da...
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.
As an alternative, if anyone knows of a way to use API calls to extract the metadata that would be just as acceptable solution 🙂