Search Microsoft Fabric Ideas

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

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

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

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

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

Datamart refresh via power automated

Datamart refresh via power automated Please add the possibility to update a datamart via power automate. This is already possible for Power BI datasets but not yet for datamarts Thanks,

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

Export / Import Datamart

Hello, i've an idea to improve Power BI Experience for developpers about datamarts.

Indeed, actually we can't export / import a datamarts like dataflows with json file per example.

It's interesting to industrialize the data model with an application for customers.

Best regards, Maxime LUIS

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.

Power BI

Datamart Source creation available for a team

In most companies, a single Datamart Owner cannot be alone to be able to add all new Datasources : this is a team work, so co admin is not enough for a Data team : the existing Power BI Datamart experience so far does NOT allot to add a new Datasource. When you are administrator of the Workspace, you should be able to add a datasource to the Datamart.