March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
11-03-2018 00:05 AM - last edited 11-03-2018 00:06 AM
This report is sourcing from MS official DAX Reference site by using a dynamic way to extract the data based on CSS selector; Visit my blog for more Power BI tips and tricks: funbiworld.com
Methods:
Using CSS selector to directly retrieve Functions Name and Link from the parent (DAX Category) page. Then use Custom Functions to get details per each Link.
Key M Scripts:
Source = Web.BrowserContents(DaxGroupURL), #"Extracted Table From Html" = Html.Table(Source, {{"FunctionName", "[id*=""api-doc-contents""] > H1,[id*=""api-doc-contents""] > P,[id*=""api-doc-contents""] > H2"},{"Link", "a[href]", each [Attributes][href]}},[RowSelector="[id*=""api-doc-contents""] > H1,[id*=""api-doc-contents""] > P,[id*=""api-doc-contents""] > H2"]),
Custom Visuals:
Using Hierarchy Slicer and Text Filter to make a better browsing experience.
eyJrIjoiMWI2YjFmZDAtNWRlYy00ZDliLWEzMGYtZjUzOGVmMGFlN2Q2IiwidCI6ImJlZWY0NDQyLTg2NzgtNDM0MC1hYWQwLTlmZDY2Yjg1ZjRlYSJ9
Very useful information, Thanks for sharing
Proud to be a Super User! | |
@EricDong , this is absolutely awesome and so useful! By any chance, would you be willing to share the pbix file with me? I'm hopeful that I can learn a lot from this. Many thanks!
This is pretty awesome!!
Hello,,
This is awsome. Is it possible you can send me the pbix file for this?
Thank you,
Hi, this is so useful! Is it possble to receive the Pbix?
Thank you
Great job Eric!
Hi Eric,
Great job sir!
is it possible you can send me the data file and pbix file for this? would be very educational for me as a beginner and would realy help my learning
hi is it possble to receive the Pbix - thanks in advance