Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
With a Power Automate flow triggered from a POwer BI screen, I issue a Power BI Query, get the results and write to a CSV File.
An example is:
Power BI: Power Automate button executing flow which executes DAX query on Power BI dataset - not returning all columns.
Sample:
Evaluate
FILTER(Master,[Serial Number] IN {"621927000017","621927000018","621927000021","621927000022","721927000015","721927000016","721927000017","721927000018","721927000019","721927000020"}
&& [End Customer NAGP] = "24/7 Inc.")
Notice that I dont pass a list of columns since I want all columns.
When I execute this, it is not writing some columns. It should not be size as this only produces about 10 rows (250 columns).
When I execute this with DAX Studio, it works perfectly.
Also, this does not happen with every instance of the flow - but always happens on the same query instance.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.