Forum Discussion
innocence84
Helper I
3 years agoHow to run dynamic management view queries within dataflows
Hi all,
I want to find dataset sizes and saved them into tables via dataflows. I found this URL: https://learn.microsoft.com/en-us/power-bi/enterprise/service-premium-large-models
I created a new dataflow and run the query via Azure Analysis Services connection:
let
Source = #"Dictionary Size Query",
#"Drill down" = Source{0}[Value],
Custom = AnalysisServices.Database(#"Workspace URL", #"Dataset Name", [Query = #"Drill down"])
in
Custom
Then I exported the dataflow. When I try to import the dataflow, I got the below when exception:
How can I run dynamic management view queries for Power BI assets (datasets etc) within dataflows?
Thanks
No RepliesBe the first to reply