Table Historification for Dataflows
Power BI relies on having all data in origin, and that's not always the case. With operative systems, often only current values are available, but you may need historic perpective on them. It would be cool to "enable historification" so that at each refresh it adds a new "photo" of the table(s) w...
Expand the actions available through REST API for Power BI Dataflows
External tools sucha as Tabular Editor 3 could make working with dataflows much much faster. The online experience is fine, but there are some repetitive steps that you know you'll have to do anyway, so it would be great if we could create them all at once with tabular editor 3 and then update a...
Please sort Query Lists alphabetically in Power Query Online when merging Queries
Hi, when you merge queries in power query the list of queries is chronological, the latest query you generated is at the bottom. While this works fine with a few queries, it does not scale nicely for more elaborated dataflows. Please sort them alphabetically or show the full folder structure to e...
Use unambiguous date format in dataflows
It looks like dataflows use american style dates, but that's quite confusing if you are used to dd/MM/yyyy. Why not use an unambiguous format such as dd-MMM-yyyy or even yyyy-MM-DD when is a date? or even better let the user easily choose ithout changing all your system settings. "guess the ...
Make dynamic axis take into account the space required to properly show labels
If I set data labels to go below, I really want the labels to show below, but the automatic axis max and min values do not take that into account, and poor label position ensues. please fix it here's what I mean https://twitter.com/AgulloBernat/status/1450096610550157317
Allow rotation on data labels
with horizontal data labels always, sometimes few data points can display its value, for some charts it would help if data labels could be displayed vertically, for instance. Also it would be good to have some control on when labels are hidden or not, sometimes it's ok to have fariry close labe...
Create dimension table Wizard
It is often the case I have a big fat table and I am trying to model it in a few dimensions.
To do that I create a reference to the query, select the customer ID along with all the attributes of the customer and then remove duplicates by customer id.
This process could...
New dax function: COLUMNAMESINSCOPE
There should be a COLUMNNAMESINSCOPE(table) which returns a single column table with the column names of the table which are part of the filter context -- for multigrain fact tables it would ease the DAX I think.
I can have a small calculated table with the names of the attrib...
Button to force full refresh on a dataflow
If your source data changed you might want to force a full refresh
right now there's no easy way to force it and workarounds are needed
this should not be like this
Clear visual indicators for query loading and include in data model refresh
Load to the model and include in model refresh are two very important flags tied to each query. However only the first one is somewhat visible by default through the italics of the name. That is insufficient.
There should be icons along each query showing if they will load an...