Getting Data From DataMart into Excel

[CalexUK]

Hi All

Im trying to connect to a DataMart from Excel ? 

I want to get data from Datamart either into Excel or Power Automate but cannot see any options any ideas ?

I can then List Rows and built some HTML tables that go into a Mail, I can do this but 

Most Gratefull if you can help ?

KIndest Regards

Paul

[v-rongtiep-msft]

Hi @CalexUK ,

As far as I concerned, now Power BI does not support export data to excel in datamart. You can create an idea here:Ideas (powerbi.com).

Users can build reports with the datamart or use Analyze in Excel, and can also connect to the datamart or underlying dataset from Power BI Desktop.

More details: Sharing and discovery with datamarts (preview) - Power BI | Microsoft Learn

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.