Refresh from access restricted Excel workbook
In addition to password protecting workbooks, Excel also supports restricting access based on users (ACL). It's a common practice to ACL workbooks in Excel to limit access to confidential data, that is used as a data source for PBI reports/dashboards. Today Power BI fails to refresh from access r...
Reverse sorting
Charts only sort one way. This is especially problematic when visualizing negative numbers on something like a stacked bar chart. Need to support both ASC and DESC in sorting. I thought it was supported before, but don't see it in Nov'16 release.
"Include in report refresh" doesn't work when query is referenced
Unchecking "Include in report refresh" is supposed to stop refreshing the query, yet if you reference that query in another query (something you'd do if you wanted to hold a local cache of the static data *not* to be refreshed), it disregards the setting and refreshes it again. Clearly a bug. Ple...