run a query against a powerbi visual dax query from multiple tables in Power automate
I have a table visual in powerbi built from multiple table joins. I did copy the dax query from performance analyzer & I'm trying to run a query against a powerbi dataset in Power automate, but in Power automate there is a box which is "Dataset" as marked below in the picture, What value should I put? I'm confused since the table visual & the dax query behind it uses 3 tables.
Solution
Select the dataset or Semantic Model that the three tables are in. If you select the right workspace, the Dataset will dropdown relevant values.
- run a query against a powerbi visual dax query from multiple tables in Power automate
- PowerBI doesn't Refresh
- How to group/summarize and sum the amount of the lates date in DAX
- Publish to web button does not appear in Power BI Service
- Selecting column based off of current month
- Compare 6 month vs 6 month on a chart bar
- ArgMax and Color properties: Unable to encode BOTH line end point marks AND highest/lowest circle marks
- How to add Power BI reports in Android native app in 2019
- DAX measure: if statement to return a variable as blank based on condition
- Sort Card (new) Visual in Power BI by Rank
- How to pivot/unpivot data for a visual in Power BI without using Power Query
- PowerBi data refresh from the source using a set value
- DAX Query/Expression syntax question ":="
- Data Flow Gen1 with Dynamic Data Source/Pagination
- Power BI multi language report, adding language to url is not working
- power bi donut and slicer
- Sum Values Which Appear In Both Tables
- Why is this small query in Power BI using several gigabytes of memory?
- How to dynamically provide colour hex codes (from a dataset) to Deneb (Power BI) Visualizations Using Vega/Vega-Lite?
- How to pass parameters in embedded Power BI paginated report?
- Power BI import PBIX file with quarkus-rest-client
- Create new Power BI report embedded in Angular application
- Hot to get subtotal only for one column in Power BI Matrix
- How to create slicer from column name
- Error at accessing Azure Maps Geographic API Endpoints from Web query in PowerBI
- ALL() function returns only non repeated values in PowerBI formula
- Forecasting Multiple Linear Regression Trends on Same Time Series Data Visualization
- Power Bi Conditional column on table row[0]
- Deneb (Vega-lite) - Access Other Columns in Axis Label Expression
- Extracting date from block text giving errors