Micaela Oliveira on 1/25/2024 11:21:34 AM
Power BI
Datamart
create cancel refresh button for datamarts
allow power automate to create a refresh sequence between datamarts and dataflows
Joao Victor on 9/19/2022 7:02:38 PM
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.
Charles Webb (administrator)
We are planning this work as mentioned in the Datamart 2023 January Blog.
Steven Arrington on 9/28/2022 4:20:53 PM
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.
Didier Maignan on 11/22/2022 10:09:04 AM
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.
Administrator
Thanks for voting! We've delivered functionality to take over ownership.
Andres Martinez on 9/30/2022 2:44:18 PM
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...
Didier MAIGNAN on 3/19/2024 3:24:44 PM
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.
Dane Griffith on 4/10/2023 10:48:15 PM
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?
Chris Colemnan on 5/23/2023 5:03:49 PM
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.
Priyanka Gaikwad on 7/26/2023 12:34:58 PM
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.
Holger Schimanski on 7/4/2023 8:01:39 PM
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.
Administrator
We are actively in the process of implementing support for Datamarts with the Fabric Git integration. We will provide you with timelines as soon as they are available. Your feedback is greatly appreciated.