Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
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.