Forum Discussion

innocence84's avatar
innocence84
Icon for Helper I rankHelper I
3 years ago

How 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