parameterise directquery using source data
I'm trying to set up a parameterised directquery to an Azure SQL database (for D365 finance and operations), but when I create the source query to bring a list of values to feed into the parameter query, PowerBI says that the query contains steps not supported in a live connection. The step that...
STATUS
DETAILS
Needs Votes
Create DAX programmatically in PowerQuery then execute in PowerBI as a measure
I would like the option to be able to build a PowerBI model using some external DAX code, perhaps importing formulas created in Excel into the PowerBI model to create Measure tables where there are a lot of similar measures, that could be created from an Excel / PowerBI formula. The only problem...
STATUS
DETAILS
Needs Votes