Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
let
Source = #"Dictionary Size Query",
#"Drill down" = Source{0}[Value],
Custom = AnalysisServices.Database(#"Workspace URL", #"Dataset Name", [Query = #"Drill down"])
in
Custom
How can I run dynamic management view queries for Power BI assets (datasets etc) within dataflows?
User | Count |
---|---|
34 | |
21 | |
21 | |
14 | |
12 |
User | Count |
---|---|
26 | |
19 | |
18 | |
18 | |
14 |