Submitted on02-17-201508:37 AMSubmitted bymourad1on02-17-201508:37 AM
In Tabular SSAS model relationship is limited. Can we have the same or equivalent capacity for relationship on SSAS Tabular and Multidimensional. - Enable relationship on different granularities. - Enable multiple relationship. - Allow, Many to Many / One to Many / Many to One...
... View more
Submitted on02-17-201508:23 AMSubmitted bymourad1on02-17-201508:23 AM
The new Data VIsualization as Power View can be directly used by end user to create their own reports. Also, We can propose some predifine report. The development tool is Visual Studio. It's enable to manage the source code and to facilitate the deployment on different environment.
... View more
Submitted on02-17-201512:50 AMSubmitted byisaacrajanon02-17-201512:50 AM
Sometimes data sources such as JSON could have both records and lists within the same column. This could be because of poor data structure. Currently BI designer does not provide a means to distinguish between which cell is a list and which one is a record. column
... View more
Can we open up Power BI to allow other creative thinkers out there to create new visualizations that can be posted on Power BI dashboard? As long as they have certain parameters (Name, chart types (visualization types), input data, scale, whatever, etc.) they can call API that can draw that visual to be displayed in Power BI. This opens up creative ways to display data and allows Power BI to be extensive and flexible.
... View more
What if I want to see statistics on my outlook emails on a dashboard? how many emails I received per day, per week, over last month, group by alias group, etc. # of sent, spams, emails, etc. my quota compared to others, etc. nothing sensitive would show up here, just simple statistics as compared to others who also opt in to have their outlook statistics pulled.
... View more
this is something similar to the scroll on the BING.COM homepage toward the bottom. so imagine I am a visitor to a main page where there are many links to other Power BI sites. I can use the quick preview link on the bottom to preview the sites. Also, this can be used in the Power BI Designer where I can quickly preview the Power BI dashboard that I am building before it is being deployed. I want to preview to see what it looks like if I were to deploy the content.
... View more
Create an area on a report designer or dashboard for each location or report on the dashboard that if the user clicks on it, it would bring up an Insight window explaining what is on that report/dashboard. What insights can be gained from viewing the data. What are things to watch out for, etc. this allows the report builder / dashboard content organizer to help the user understand the data they visualize. This is nothing more than a popup box with free-form text that allows the report writer to customize the message they want to convey to the consumer of the report content.
... View more
My customer requested to have search capability where end user can search using Keyword across all the asset of Power BI – Dashboards, Reports, Data sets, and Queries. They don’t want people to re-invent the wheel and re-create bunch of reports and dashboards. Instead they want to allow to search for it and if its available, they can request access to that report of dashboard to the owner of that report. Similar to SharePoint Online search. Perhaps Azure Search can be part of this capability?
... View more
Make analytics drag and drop e.g. - drag and drop a trend line onto to the board. This should be interactive as well - show outliers as a different colour, or the ability to exclude them. - show a little panel that gives you the descriptive statistics, and does a chart call out to show the dispersion (for example).
... View more
MOre third party data sources e.g. Google Analytics, Tableau TDE Files. Make it more specific that OData so that the data source is really drawn out.
... View more
At the moment, Power Query does not support salesforce custom domain. You will get javascript error when you try to log into custom domain.
... View more
The relationships of all the tables in power query should stay when changing the database connection. Today, when I try to use existing workbook to connect to other azure db, as soon as I change the connection, all the relationships are gone. It took me half of day to rest all the connections since I have more than 50 DIM and FACT tables.
... View more
If multiple tables are imported from SQL Server and relationships exist between those tables (in the database) the very same relationships also get created when you import those tables into Power BI. For OData feeds you can also specify tables and relationships but the relationships are then not created automatically within Power BI. As OData becomes more and more important this would help a lot and bring more services to export their data as OData feed to allow reporting in Power BI.
... View more