Create new dataset based on Azure SQL database using REST API
For now it is not possible to create new dataset based on Azure SQL database using REST API. It is working for Azure Analysis Services - https://msdn.microsoft.com/en-us/library/mt203562.aspx. It will be helpful in automatic Power BI deployment.
Ability to manually manage SQL queries which are sending by Power BI visuals to database because they are not optimal (DirectQuery mode)
I've tracked with SQL Profiler that each visual of report is sending own and very often not optimal hard query to retrieve data in DirectQuery mode. It will be helpful to have ability to change it per each visual then rendering will be much faster and amount of errors will be less.
Create a documentation explaining Power BI Desktop and Service architecture
Create a documentation explaining Power BI Desktop and Power BI Service architecture (engine, how visuals interact with source, data flow in DirectQuery/Live/Import mode). I know that Desktop has SSAS instance behind and I can connect to it using SSMS as to usual SSAS model. So I interesting to u...
Progress bar for report refresh in Desktop
It would be nice to see a progress bar for each query while refreshing. When you work with huge datasets it will
Progress bar for report refresh in Service
It would be nice to see a progress bar for each dataset while refreshing. When you work with huge amount of data it will be very helpful.
Power Query (M) code optimizer button
The idea is to add M code optimizer button which can duplicate your query but will group data type change steps into one single step (where it is possible). The same can be applied for renaming, replacing etc. For instance, If you add many data type change steps and after you implement sorting ...
Add a link to Power BI User Groups Website to Desktop
Add a link to Power BI User Groups Website to Desktop start page. There are too many Power BI users who want to meet other Power BI enthusiasts, ask questions and share knowledge with them. Most of all don't know about Power BI User Groups. It can help the Power BI community to grow rapidly. W...
Add auto-generate Power Query (M) functions
Add auto-generate Power Query (M) functions Add several functions which will autogenerate lists for months, countries, languages (short and long), currencies and countries with languages and currencies. It can help to create dynamic reports based on Get data from Web results. For instance, you...
Convert result of Power Query (M) code to persisted data like 'Enter data'
Convert result of Power Query (M) code to persisted data like 'Enter data'. For instance, you've loaded a data from Web and then implemented 100 steps on top of it. But you want this result to be persisted. And then be able to just copy M code to another PBIX to have data. There is an option to...
Create Mashup engine documentation (how it processes data)
Create Mashup engine documentation (how it processes data). We know how xVelocity works but know nothing about Mashup engine. How it is using connector, loading data and store it etc.