- Subscribe to RSS Feed
- Mark as New
- Mark as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content
Power BI Power Automate button, calling flow which performs DAX query not returning all columns.
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.
-
Gionedis
on: Copying Table with Filters is Ignoring Filters
-
Stinkys
on: March 2025 Update - Error fetching data for this v...
- rschimmel on: Snowflake connector isn't showing views after Marc...
- Tomasz_Skoczyla on: March 2025 update - Style preset error
- TwanVerdonschot on: Conditional Formatting - Field Value not working a...
- njf on: Stretched App's Logo in Home Page "Recommended"
- pedrodr99 on: Button Slicer - Label - Color change not working
-
v-xiaoyan-msft on: Default Chart - Shape Map Is Not Working As Expect...
-
v-xiaoyan-msft on: Error (Exception from HRESULT: 0x80070002)
-
v-xiaoyan-msft on: Card (new) - SVG images dont render correctly
- New 7,869
- Needs Info 3,502
- Investigating 3,602
- Accepted 2,084
- Declined 38
- Delivered 3,964
-
Reports
10,148 -
Data Modeling
4,092 -
Dashboards
4,081 -
Gateways
2,103 -
Report Server
2,098 -
APIS and Embedding
1,949 -
Custom Visuals
1,770 -
Content Packs
521 -
Mobile
353 -
Need Help
11 -
Show and Tell
3 -
General Comment
2 -
Tips and Tricks
1 -
Power BI Desktop
1