You’re offline. This is a read only version of the page.
Announcements
I've built a flow with a "run query against dataset" from Power BI step, with a google doc file output (Fig 1). I've gotten it to run in the format I want, and it's returning all the columns I've requested except the Amount column (Fig 2) - which of course is imperative.
I can only assume it's an issue with Amount being a summed column, since that's the only apparent difference between it and the other columns that are working. I thought at first perhaps it was an issue with the column name (ex: "TransactionCurrency" vs. "SumTransactionCurrency") but I've tried every conceivable version of the column name and it's still not working (Fig 2).
Why is it returning the other columns but not the Amount column? Does it have something to do with it being a column of summed values, and if so how do I fix it?
Remember that DAX queries are run in a filter context. Your easiest remedy would be to create a table visual in Power BI that has your desired data, and then to steal borrow its DAX code via the Performance Analyzer or the Excel "live" export option.
Share
Report
All responses (
Answers (
8,474
