Password protected query and report
I need to protect our SQL query so that no one can view or edit it (or change the server address), but leaving to the users the possibility to edit visuals and datasets (password protected gear icon in the query editor). It would be also useful a lower level password protected .pbix. We need to k...
More DAX functions: Unpivot calculated columns and max/min of multiple columns
It seems there are no DAX formulas to unpivot multiple calculated columns in a new table and to easily calculate min or max of multiple columns. Tried to easily calculate min or max of multiple calculated columns with a function, but there's none. Then tried to unpivot my calculated columns (to...
Rename/Sort fields at visual level, with possibility to return to original name/sort
Allow users to rename fields (axis, legend) at visual level, with possibility to return to original name. Allow users to custom sort (not also ASC or DESC) moving fields in the way they want, with possibility to return to original configuration.
Query editor settings import
Allow users to import the datasource and transforms settings from one or multiple previously developed .pbix. Then the new table/s structure are added to the dataset.
Percentage labels on pie chart when the vales are measures
Allow users to visualize percentage labels on pie chart when the values are measures, and chooese if the percentage is displayed beside the values or alone. Quick calc is not a solution and some say is not working on the online version at all.
Duration managed like a value
Data in duration column cannot be proper summed in the visuals. It would be fine if, when added into a visual, the numeric field would be automatically formatted excluding for example the "0.00:" when the result of the sum is 0.00:15:23
Dynamic hierarchy fields
Add an "add selected columns to a hierarchy" or moreover "add other columns to a hiearchy" button to have dynamic number of levels in a hierarchy. This is very useful also for columns that represent a hiearchy resulting from a "split column by delimiter" that varies at every update.
Calculate and represent concurrent events
When having a table with start datetime and end datetime (second-granularity) is impossible to count concurrent events. As a workaround one has to build a calendar table with a crossjoin for every second in each day, and then a calculated column with concurrent eventsfor each second and the RAM b...
Switch origin from DB to Gateway
Allow developers on Desktop to develop without VPNs using a connection to the DB through the gateway. So the datasource to be set is the gateway itself with power bi credentials, internal or external to the organization of the gateway owner that gives authorization.
Permission and security of report download
Tenant admin capability to assign permission of report download in .pbix protecting copy and distribution, using power BI online as unique channel of data monitor.