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...
Support Direct Query SQL Result cache
with the introduction of M Parameter, a new class of use cases became Possible in PowerBI, Currently it is possible to send an M Parameter and get back some heavy calcul...
Make a DAX measure react to internal filter selection in the same Visual
I have a use case where I want the DAX measure to update when I select some rows in the same Visual, Currently DAX measure capture only external filter selection not internal Selection
it is a very common pattern in GIS, I am using M Parameter to return a cluster of some points selection...
concatenatex should respect the Selection Order
in this example, I am using concatenatex to build a line string geometry that is rendered on the fly by the Icon Map, unfortunately concatenatex has no way to keep the s...
Preserving Data Types With SQL Queries In Power Query And Power BI when Using BigQuery and other Connectors
Currently when running a custom SQL Query using BigQuery, PowerBI send another Query just to check the Data type, it slow the performance and honestly it is not necessary, this behavior was fixed for SQL Server as per Chris Webb blog here https://blog.crossjoin.co.uk/2021/09/12/preserving-data-t...
Don't refresh Data from Dataflow if the Data has not changed
let's say you are importing data from dataflows to a PowerBI dataset, can we have an option when we refresh PowerBI dataset that the connector to the dataflow check if the table last modified date has changed or not, if the date has not changed since the last refresh just ignore the refresh.<...
Datamart, make the auto generated dataset optional
we have a lot of cases where we prefer to turn off the auto generated dataset
- When Datamart is used only to share data
- When the dataset is already built using PowerBI Desktop/Tabular and Datamart is only used to store Data
The Ri...
Dataflow, load to an existing Datamart
Currently when you create a dataflow, it give you the option to either create a new dataflow or a new datamart, which is a great option for a new user as you get a full Online experience from Data Prep, Modelling to Final reports, and a good option to start a new standalone report
Datamart should not block managed managed identity access.
we have a use case where we want to Extract Data from Datamart and load it to an Azure SQL DB, the data will be used for an OLTP scenario.
as of today, Datamart endpoint block managed identity access , as a matter of fact even Python Access is Blocked, I know it is a preview, ...