The current Gantt Chart in the Custom Visuals Office Store is a step in the right direction, but unfortunately it is pretty much useless in it's current state.

Please add an Advanced Gantt Chart for proper project management (multiple projects with multiple activities).

- Add Milestones on top of the Activity Bars based on a data column (and preferably multiple types of Milestone icons)

- Ability to chose size of the bars (the ones we have now are huge)

- Ability to expand/collapse a group of Activities (preferably grouped by project or category)

- Let report viewers decide the scale of the timeline (e.g. let them grab the timeline to zoom in or out). Currently the Report developer sets the scale Days, Months or Years up front)

- While we are at it, please add Quarters as an option for the timeline (there is a seperate idea for this in the forum)

- Customize colors of the activity bars and milestones

- Resize Activity Name column (currently it only shows a certain amount of characters which usually results in something like "Activity Name bl...."

- Add other columns net to Activity Name (e.g. Country, Responsible, Completion % etc.)

Enter Parameters Window with dynamic field updates

I can see the potential of the Enter Parameters window on Edit Queries feature, which can have a number of fields such as text boxes and drop down lists. It would be great if for example:

A dropdown list field on selection dynamically updates the returning dataset to another dropdown list field which its connected too. With this capability it could save time and the need to develop additional excel plugins to retrieve data for analysis.

The availability to connect to various data sources is already provided, but using the Enter Parameters window as a user interface to customize to pull data based on certain selection criteria would be great!

As drillthrough function we use a filter and we give value for it from other report page. I click back-button and it will take me back to where I was before. In the background filter value stays unchanged. I use drillthrough function again. Filter value changes and I see visuals filtered with that value. I use back-button again. I navigate to that report page manually and to my surprice value selected in prev step is still selected. I know that I can open my filter selections and clear selected value but I'd like to do is to start exploring my data without any preselected drillthrough filters. Filters in filter pane are a bit confusing to end-users and some of them cannot even find them.

For example: when the Power BI data model first creates a column with Data Type = 'Date', by default that column is formatted like 'Wednesday, March 14, 2001 (dddd, MMMM d, yyyy)'.

Then, I always go to the Modeling tab, and use the Format drop-down to change it to '2001-03-14 (yyyy-MM-dd)'.

Instead, I would like to be able to go into the "Options" menu in Power BI Desktop, and have a section where, for each Data Type (or at least Date, Date/Time, Decimal Number and Whole Number), I can set the default Format.

So that I don't have to manually change it every single time!

It would also be nice to add this as a setting in the Power BI Service. Set default Formats (maybe for the entire tenant, or maybe by user?) when creating a data model using the Power BI Service.

Create a way to automate the following manual steps..

Hi all

I recently wanted to change the datasource from Import to Live Query using the "Power BI service" and had a good lookaround without turning up much other than "you can not"...

However I managed to get it going, effectively maintaining my designs/visuals and changing datasource so that I can get away with publishing one report whenever my data changes.

Prerequisites:
* TARGET: A .pbix file with designs/visuals using import, no measures.
* SOURCE: A clean .pbix file using Live Query to a report/dataset published to app.powerbi.com (no designs/visuals)
-This .pbix file must have the same table as the TARGET file (ie: using the same db)

Steps:
1. Rename .pbix files to .zip
2. Copy from SOURCE => TARGET these files: Connections , DataMashup
(I used Total Commander for this as it was simplest and it supports archive files)
3. Rename TARGET file back to .pbix
4. Open TARGET file in Power BI
5. The design/visuals and the Old table structure should be visible under "Fields"
6. A yellow warning reading "There are pending changes in your queries that haven't been applied [Apply changes]"
should also be displayed
7. Click [Apply changes]
8. All designs/visuals should get an (X) and the message "Something's wrong..."
9. Now go to "Get Data" and select your datasource (i wanted to use data from Power BI services, and a previously published
reports dataset. Select your datasource and Load it.
10. The designs/visuals should get the proper data filled inn (connection in model checks out) assuming that the previously
published report/dataset holds the same table (same name etc).
11. PROSPER!!

If you in your TARGET file which is relying on datasource import has created measures and such, these should probably be re-created in the published report/dataset prior to following the steps above (untested).

Note: If you are unable to open the .pbix file in PowerBI after renaming it back to .zip, there might be an issue with your zip program. For my part it failed when using windows inbuildt functionality but worked when using Total Commander to copy files between the .zip files...

Hope this is of value and help.