BigQuery, add Native Query when using M Parameter
PowerBI added recently M Query support for BigQuery, this is a great achievement see example here https://datamonkeysite.com/2020/10/22/change-dimension-dynamically-using-parameter-in-powerbi/ but unfortunately without the support for Native Query, there are a lot of complex scenario where we can...
support Parameter Action
PowerBI recently added M Parameter, I appreciate the Purpose of it, is to support Big Data Workload, as the users needs to control exactly the Query sent to the Data Source. but one side effect of this features is we can do a lot of new interactive features that was either hard to do or simply im...
dataflow, add the Option to export a dynamic file name
PowerBI dataflow by default export a static file name, which is a great option, if you want only to overwrite the result. now if you want to keep the history and partition the data, a very simple solution is to add a dynamic attribute to the file name, for example let's say you have a date col...