Search Microsoft Fabric Ideas

Power BI

Datamart

create cancel refresh button for datamarts

allow power automate to create a refresh sequence between datamarts and dataflows

Power BI

Save the SQL Query from Datamart

Today, when you make a SQL Query in the Datamart you only have the option to export in .xlsx, why we can't save this query inside the Datamart to use in the creation of reports.

I suggest to make the Query and have the option of use it like a table or save inside the datamart to turn the query useful to create a report.

Power BI

Multiple Datasets from a Datamart

My impression is that Power BI Datamarts are being groomed to be a Power BI alternative to the Data Warehouse and Data mart steps in a generic data pipeline.

Here is what I would consider a generic data pipeline:

OLTP Data -> (Optional) Data Lake -> Data Warehouse -> (Optional) Data marts -> Analysis/BI/Reporting

Power BI Datamarts already support an automatic Dataset in Power BI that is then used for reports, my suggestion is to extend this to be able to manually split a Power BI Datamart into several datasets that can then be used in reports, then you don't run the risk of duplicating logic in a separate Power BI Datamart or Dataset and it becomes one place to manage the connections, model, queries, etc.

Power BI

Datamart, change the Workflow owner

The creator of a Datamart is the only one to be able to add a new Datasource to this Datamart, even with all 4 authorizations on the Datamart and admin of the Premium Workspace. When anyone else want to add a new datasource, an error message says that the action is not allowed due to lack of ownership of the [power Query Online] Dataflow.

When a company has several trustfull contributors or moving staff, the DataFlow owner should be changed or be a group or multiple users.

Power BI

Link Dataverse to Datamarts

It would be nice to be able to link Dataverse to Datamarts like we can do with Synapse to be able to do real time queries through the Datamarts...

Power BI

Deliver Datamart to GA

Datamart would be in General Availability : when they go to premium workspace the Create button would never show "Preview" joined to the "Datamart" item. We wish this since mid-2022.

Power BI

Import Data Model for Datamarts

I'm building reports off the auto-generated dataset created by my Datamart.

I found that Direct Query is much too slow and limits the complexity and number of visualizations on a report page due to performance. Query cashing isn't sufficient to speed things up.

Per the Understand Datamarts blog, "During preview, auto-generated dataset connectivity is available using DirectQuery only.". Does this imply that another option will be available once Datamarts are generally available? If not, can we have an Import data model option that utilizes Vertipaq or something similar?

Power BI

Power BI datamarts and Power apps

It would be great to have a power app connect to a power bi datamart and allow that power app to manipulate and or write data back to it. We have several datamarts created and those datamarts have the data we need fot the apps. it would be nice if we could just write back to the datamart instead of connecting to another database, dataverse or other.

Power BI

Calculated column option in Datamart

As of now, there is no option to create calculated column in Datamart similar to desktop version. We can create column in Power Query but it doesn't allow to use any measure as reference.

This feature will be very much useful for transforming data in datamart.

I request you to consider this as a part of future releases.

Power BI

Git integration for Datamart

Datamart (preview) is a great feature to enable business user-driven creation of data models and provisioning of data for reports.

With the recent introduction of Git integration of workspaces, it would be fantastic if also Datamarts could be stored and traced and reviewed in Git same like it is possible now for reports.