Need ways to plot and list individual data points.
Microsoft BI assumes that I will always aggregate data. The first things that many statisticians do is a time series plot, box plot, or list the individual data points. This is needed to determine the type of aggregation (if any) that makes sense. This is also necessary to determine if data fr...
Missing functionality
I have been evaluating Power BI as a potential tool for my company. I have been really surprised at how many fundamental things we encountered on Day 1. Most of these are "basic expectations of the client" functionality. 1. No native support for WHERE clauses. We have worked around this by u...
Need consistent formatting controls across visualizations
We need some consistent ways to format text across visualizations. There is no way to set the font color in text boxes. You cannot set the font weight is slicer titles. There is no text alignment control for Cards. Things that are basic expectations for an analysis system are tips, tricks, an...
DAX TRIM Function cannot find text columns in tables at all
Some DAX TEXT functions seem to work with text fields. The TRIM function always returns 'Cannot find column'. Other TEXT functions work without problem.
Need a visual or text box capable of displaying a multi-line, aligned text field under Direct Query.
A visual that is capable of displaying a muliple-line CHAR(13) or CHAR(10) delimited text field (for example, a postal address) would be very useful. In it's current state, this required major workarounds in Power BI.
I have a hard time recommending Power BI because basic t...
Give people next steps to address the "To turn on Q&A, we need to create a local index of your data..."
This message is a dead-end. At the very least, tell people where to look for next steps.
This also exacerbates the major problem in Power BI of not being able to display text from database columns when using Direct Query. I cannot use Text boxes to display text from my datab...
Export to PDF should not center report content.
I noticed that the export to PDF centers everything in the PDF.
It would be far better to use the alignments set in Power BI.
Need guidance on how to implement a stored procedure or simple SQL SELECT using DirectQuery
At this time, I have not found any way to successfully call a SQL Stored Procedure or SQL SELECT in Power BI using DirectQuery.
I keep getting the incorrect syntax near word EXEC.
If I try a straight SQL SELECT, I get the:
Microsoft SQL: The...