Power BI Ideas

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. Support for SQL Server partitioning when using DATETIME2 and DATETIMEOFFSET

    When Power BI use direct query to SQL Server, and filter a column with a date, it will cast the date to DATETIME and not to the columns data type (for example DATETIME2(0) and DATETIMEOFFSET(0)):
    "
    WHERE (
    (c1 < CAST('20191122 00:00:00' AS DATETIME))
    AND (c1 >= CAST('20190923 00:00:00' AS DATETIME))
    )
    "

    This creates two problems. The SQL Server documentation is clear on that DATETIME should not be used in new projects:
    https://docs.microsoft.com/en-us/sql/t-sql/data-types/datetime-transact-sql?view=sql-server-ver15

    The second and biggest problem is that SQL Server will not use the partitions if the data type is another than that of the partitioned column.…

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Data Sources  ·  Flag idea as inappropriate…  ·  Admin →
  2. 1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Data Sources  ·  Flag idea as inappropriate…  ·  Admin →
  3. More frequency options by schedule refresh on directquery datasets

    On a dataset with directquery you can create a 'scheduled refresh'.

    Frequency options: 15 min - 30 min - 1 hour - 2 hour - 3 hour - daily - weekly.

    Is it possible to schedule this every minute?

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Data Sources  ·  Flag idea as inappropriate…  ·  Admin →
  4. Leverage incremental refresh with R-script

    We have a need for running R scripts on large datasets, but have performance issues when re-pulling historical data. To ease the workload on our gateways and database backends, it would help if we could execute R scripts against data frames/tables that have already been imported into the data model: specifically, tables/data frames that are populated using incremental refreshes

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Data Sources  ·  Flag idea as inappropriate…  ·  Admin →
  5. Option to translate data into another Language

    I tend to work with data that is of different language from time to time. And I was wondering if there is any way I could just change it automatically inside Power BI right after I import the file instead of manually translating it.

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Data Sources  ·  Flag idea as inappropriate…  ·  Admin →
  6. Display Server/DataSource name on Desktop

    In Power Bi Desktop, show Server Name somewhere just like how SQL Server shows Server connected to on the bottom Right side.
    It is confusing whether am connected to DEV or UAT or PROD ?
    if it is always visible on the screen, it would be nice.
    SQL Server: Server | user | Database | Execution Time | # Rows.

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Data Sources  ·  Flag idea as inappropriate…  ·  Admin →
  7. Offer connectivity to Azure resources in China through custom connector, template, or API connection.

    Would like to access our resources in China. This is currently not supported or even possible.

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Data Sources  ·  Flag idea as inappropriate…  ·  Admin →
  8. Restore the connector for Stripe in the "Get Data" option

    This is a bit of an odd "idea", I was referred here by the Support Team on the Power BI community site.

    It seems in the latest version of Power BI Desktop (Version: 2.75.5649.582 64-bit (November, 2019) - it also appears to be the same in the browser version) the Stripe data connector has been removed.

    We rely very heavily on this connector, I realize it was a Beta connector, but it would be great to have this restored. Luckily existing connections are fine, but I can no longer extend any reporting.

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Data Sources  ·  Flag idea as inappropriate…  ·  Admin →
  9. слишком много проблем с подключением к данным

    Настроили отчеты, часть берет данные из SQL, часть и SharePoint и файлов SharePoint, все работало, спустя пару месяцев все перестало работать особенно с данными SharePoint, никаких четких инструкций нет, жалуется то на доступ, то на драйвера к файлам, то на их битность, учитывая что установки производят ИТ служба, объяснить им что надо крайне сложно, в итоге ничего не работает

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Data Sources  ·  Flag idea as inappropriate…  ·  Admin →
  10. Ability to use PowerBI credentials to access the underlying DB or prompt DB credetials while viewing the report in Service

    Currently the dataset are published with fixed credentials to the service. Also there are options to manually refresh the dataset credentials. But, we need to be able to pass the user credential for each user viewing the report/dashboard. We are facing this scenario where we have implemented RLS and Data masking in our reporting DB, but now we have to do it all over in powerbi model. We don't want to maintain these in two places, instead we just want to be able key in the credential of each user accessing the report/dashboard.

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Data Sources  ·  Flag idea as inappropriate…  ·  Admin →
  11. Auto Publish

    Please make auto publish feature just like auto refresh

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Data Sources  ·  Flag idea as inappropriate…  ·  Admin →
  12. Need the ability to change CDS connection string using the datasource settings pane.

    Right now, the only way to change CDS connection string (say from Dev to Prod) is to change the Advanced Query for each and every entity. It is really frustrating to having to change the connection it when there are large number of entities. Need easier way to update the connection in one place just like SQL server and other sources, from the Data Source Settings pane.

    6 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Data Sources  ·  Flag idea as inappropriate…  ·  Admin →
  13. Allow power bi to connect to a particular blob file from a subfolder in the Azure Blob Store

    Power bi connection to individual BLOB files from a sub folder in the Azure Blob Store. Now its taking all the files details in the particular folder. But not allowing to select a particular BLOB file in the single folder

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Data Sources  ·  Flag idea as inappropriate…  ·  Admin →
  14. Right Click Option for "Data Source"

    When we right click on any Source in Power Query Editor we can see a window with multiple options Example Delete,Rename etc .If you can add "Data Source Setting" options to the right click will make life very easy and every single source has their own Data Source Setting.

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Data Sources  ·  Flag idea as inappropriate…  ·  Admin →
  15. Recognize newly added column in the source file

    Add the functionality to recognize newly added columns in the source excel file. Now whenever a new column is added in the source excel file and power bi report is refreshed, the whole report breaks down as power bi does not recognize newly added columns. When someone new is trying to learn Power BI, this simple problem can throw them off. A learner should not have to go to the advanced editor to change codes just because he/she has added one column in the source excel file. Please add this functionality, it is available in other BI software in the…

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Data Sources  ·  Flag idea as inappropriate…  ·  Admin →
  16. Procedures in mode Direct Query

    Allow the use of procedures, (begin and) (declare), etc. in the DIRECT QUERY mode sql statement. Currently you can even use it pulls the data but when you close Power Query it syntax error

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Data Sources  ·  Flag idea as inappropriate…  ·  Admin →
  17. install Microsoft.ACE.OLEDB.12.0 on Power BI Service refresh infrastructure

    When you have an Access Database (.accdb) file in SharePoint Online and you load from a "SharePoint Folder" data source then load that file, it loads fine from Power BI Desktop but when published to the services you can't refresh without an On-Premises Data Gateway which has Microsoft.ACE.OLEDB.12.0 installed. Please install Microsoft.ACE.OLEDB.12.0 on the built-in Power BI Services data refresh infrastructure in the service so we can do such a refresh without an On-Premises Data Gateway.

    0 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Data Sources  ·  Flag idea as inappropriate…  ·  Admin →
  18. Paylocity connector

    Please add connector to Paylocity.
    https://www.paylocity.com/

    4 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Data Sources  ·  Flag idea as inappropriate…  ·  Admin →
  19. Ability to get city and country from a user in Azure AD or/and Office Office 365 users

    Most of the time we've information based on users of our Azure AD or Office 365 users list especially in SharePoint list with "Author" and "Modifier".
    In Power BI these fields returns some profile information as office, department, ... but not City and Country.
    We need these information to display data related to a user on maps.

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Data Sources  ·  Flag idea as inappropriate…  ·  Admin →
  20. ODBC - Initialise connection

    In Oracle ODBC connection I would like to have the possibility to initialize the session. e.g. I would like to set the dataformat only for the session with an ALTER SESSION sql statement.

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Data Sources  ·  Flag idea as inappropriate…  ·  Admin →
← Previous 1 3 4 5 119 120
  • Don't see your idea?

Feedback and Knowledge Base

Ready to get started?

Try new features of Power BI today by signing up and learn more about our powerful suite of apps.