Please add ODBC data source connectors for Dataflows. Many of our queries connect through ODBC drivers because direct access to the DB2 database is not allowed through the DB2 driver.
I would like to be able to query the tables, columns, DAX calculations (columns and measures), and data source queries for datasets published to PowerBI.com. This would allow me to determine if I have many similar models that could be combined, or if I have multiple models defining the "same metr...
The metadata is exposed through the Scanner API or in Purview - Announcing Scanner API (Admin REST APIs) enhancements to include dataset tables, columns, measures, DAX expressions, and mashup queries | Microsoft Power BI Blog | Microsoft Power BI, , Use Power BI with Azure Purview to achieve better data governance and discovery | Microsoft Power BI Blog | Microsoft Power BI
If there is a need to expose more granualr information in one or all of these capabilities please do open a new idea/s with the specific asks so we address them
The conditional formatting for values is wonderful. However, it would be great to have the ability format subtotals and totals, as the variation on those fields are often even more important to draw attention to.
In our firm, we are using Power BI to connect Redshift and SQL Server through import and Direct Query. We used to create SQL queries in Advanced option through power BI to connect with SQL Server. This helps to limit the data size as we have billions of record on the source file. But unfortunatel...
Need a way to be able to invert the y-axis without fudging data to make it work.
The option to invert the Y axis exists today within the Format settings.
Is it possible to export data in a Matrix visual in a traditional row/column excel format instead of the tool converting it to a flat CSV file.
Exporting a matrix while retaining the layout of the matrix is now supported in the Power BI service
I want to be able to write a question that says "Revenue - Tax over time" and have Q&A create the calculation for me on the fly.
We are happy to announce that Q&A now supports the following arithmetic operations:, to learn more: https://powerbi.microsoft.com/en-us/blog/power-bi-september-2020-feature-summary/#QA_arithmetic
Please add "Monthly" subscription option. We have many enterprise-level reports which must be consumed at monthly cutoff (which varies by business area). A daily report is far too frequent, and weekly will miss month end one in seven times :)
Currently the preview of Datamart's can be enabled or disabled for everyone only.I'd like to be able to enable it only for select users or security groups (basically admins only) to work out how suitable it is for our business before making it more widely available (or not).
We've heard your feedback and are looking into this.
In April 2022, the product team announced the subscription management was available for workspace admins. Subscriptions created from a workspace's app are evidently not supported, and nobody from the product team ever thought to mention this. They still haven't responded in the <a href=...
We're happy to announce improved management capabilities for subscriptions created in apps! If you're assigned the admin role in the workspace associated with an app, you'll be able to view and manage all subscriptions created for content in the workspace as well as the app.
Administrator
Dataflows support ODBC sources, to learn more: https://docs.microsoft.com/en-us/power-query/connectors/odbc