158 votes14 comments · Power BI Ideas » Gateways (Enterprise and Personal) · Flag idea as inappropriate… · Admin →Dimah Zaidalkilani responded
I modified the post to only show “Edit” . You can delete data source by clicking on “…” next to the Data source instance
41 votes12 comments · Power BI Ideas » Gateways (Enterprise and Personal) · Flag idea as inappropriate… · Admin →
24 votes1 comment · Power BI Ideas » Gateways (Enterprise and Personal) · Flag idea as inappropriate… · Admin →
This already works, but you specify a Folder connection, not an Excel one. Then any datasets that connect to Excel files in that folder or its subfolders should work using that same connection.
I'd like to be able to setup a connection, even ODBC, where users of that connection provide their own credentials per Dataset. For example you may have a DB2 Subsystem with a thousand databases/Schemas. I'd prefer to create a generic ODBC DSN (all our users have those installed) and when the user sets a refresh, must input user credentials
Moving from started to under consideration.
For reports please take a look at the Power BI mobile client (the Windows edition)
I agree, but it should be coupled with the ability to refresh the data on an short interval like minutes from the Client. Search related ideas using "Auto refresh data every few minutes within the Power BI Client"
Thanks Derrick! Anyone else think this would be a useful addition? Please add your vote!
Thanks for the feedback!
Item #1 is something we’re currently working on. It should be available very, very soon.
Could you elaborate a bit more regarding #2? Are you looking for a way to automatically refresh your reports within the Power BI Designer, for Desktop-based scenarios? If I understand correctly your ask, this would be similar to the “Connection Properties” options inside Excel, where you can configure a given connection to refresh when opening the workbook and auto-refresh every N minutes. Is that what you’d like to see in the Designer?
We need to be able to refresh from the Desktop App every x minutes, even as low as every 2 minutes. Even with a Premium node, you can only update 48 times a day. We NEED this.
For near real-time On-premise data, Round trip to portal takes too long, requires an on-prem gateway, and currently doesn't allow for 2-5 minute refreshes. Ideally, I'd like a setting in Desktop that sends the Queries to On-premises sources and once all the data returns, send it again so I get as close to a real-time dashboard as possible but accounts for variations in network and database response speeds (dynamic). Please not something that is blinky on each update.
Thanks for your feedback – We plan to enable SSO over SAP BW later this calendar year. We don’t have a more concrete timeline at this stage, but stay tuned for status updates.
Hey all – We released a preview of theming in the Power BI Desktop! Read all about it on our blog post and let us know what you’d like to see added next to the preview: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-march-feature-summary/#theme
Okay, so you got colors, how about Font Type and Sizes? I'd guess you'll have many Fonts we could list, so it may be cumbersome, but if we had a Global Default Font and could add the ones we need smaller/larger sizes on, that would be good. If it's not specified, use the Global Default. Maybe you could use an ordered list like ChartFontSizes: (10,12,8,12,9) and each position indicates which font changes.
Maybe let us define a custom pallet that can be set as the default for both colors and fonts. We must have Branded Reporting that uses Green, Black, Gray, Yellow and 20% shades of each and a specific font (Verdana) for each element. It is too painful to do this on every element of every report you create. It should start with my custom palette/fonts and let me change those if needed.
If a user puts Country, County/Province, and City in the Location field, Power BI should be able to locate it right. BUT, I found that I have to use a DAX formula to concatenate these together and use that. Power BI should do this in the background when those element are properly typed in the data.
Not sure why you are limiting DB types with Direct Query.
Great suggestion! There’s minimal control over this today and we’d like to improve this. If you need real-time updates today, you can take a look at the Developer APIs for pushing data directly into Power BI datasets. Adding your vote will help us prioritize this functionality!
We’re pleased to announce that in the May release of Power BI Desktop you can now define incremental refresh policies for your models.
At present these only apply once the model is published to a Premium workspace in the Power BI service; we’ll be bringing it to all Pro users in the future.
You can read more about it in our blog here: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-may-2018-feature-summary/#incrementalRefresh
We’re going to leave this idea open for now, so please give us your feedback while we’re in this preview phase!
1,165 votes202 comments · Power BI Ideas » Gateways (Enterprise and Personal) · Flag idea as inappropriate… · Admin →
Will finish the rest soon
The team is definitely looking at this! Let me see if i can mark as started as I am pretty certain the dev Team is working on it!
There was some mention of using PowerBI with SharePoint 2013. You may want to poke around to see if there's any substance to that or if it is "integrated". It may just be using PowerBI on SP data.
I agree. As a work-around, you could create separate Data Sources being sure to include the key/join fields for merging. Business Objects uses Class folders and Subfolders to organizes the fields into.