I have been extensively using Power Query at work to automate pulling data from 20 different excel files, access data base and other sources. What I really like about Power Query is I can reorder the columns in each of my data pulls in power query editor and then append more than 20 data tables i...
I have existing Excel-based dashboards using Stacked Area and a few Custom Combination charts: Bar / Line, etc. Right now Power BI only supports Column / Line variations. I would like to be able to select chart types for my primary & secondary axis in a flexible way, similar to Excel. This w...
We need an ability to use measures for data labels and titles. So for example we will be able to create a chart and a currency filter, so with checking different currency we will see our money in different ways and the labels should automatically change with this too.
For the Enterprise Gateway, when setting up an on-premises data source e.g. SQL Server, instead of explicitly specifying a Windows authenticated account, add a setting that just does "User current user" to pass on the DOMAIN\user credentials to the on-premise SQL Server. Similarly to the SSAS im...
If there are multiple tables that use different refresh frequencies, for performance reasons, you don't want them to auto-refresh whenever you union them. Currently this is what Power Query does and you cannot disable it.
Customizing filter for default selection is good to have feature. For Example, if month is displayed in filter, so allowing filter to select Current month automatically will be a great add on feature.
At the moment it seems the only way to connect to Azure SQL Database or Azure SQL Data Warehouse is to open up the firewall to all Azure services. This means anyone with a power BI account could access my DB if they knew the user name and password. This is not so bad with Azure SQL Database as ...
The new auto Date Hierarchy which came out in the November update is excellent, but does not seem to be available when connecting to a SSAS Tabular Model. Desktop appears to recognise a Date field, but will now activate the hierarchy action.