Create a datamart with multiple datasets

[Anonymous]

Hi

I want to create a Datamart with multiple Datasets in it from the same Workspace (Premium). However, once the datamart created in Power BI Services i don't see the button to import Datasets (i see for many other sources like Dataflow, Dataverse, etc. but not specifically one namee "Dataset").

Thanks for your help

[lbendlin · Accepted solution]

Datamarts are lipstick on a dataflow pig.  They come BEFORE a dataset, and cannot consume one.  You can trick the pig by importing from an SSAS source but that would be mean.

[Anonymous · Accepted solution]

Hi, @Anonymous 

If possible, export data from the dataset to a dataflow. Once the data is in the data stream, you can easily connect to this data and import it into the datamart.

Another approach is to export the dataset data to Azure SQL Database or any supported SQL Server, and then connect this database to the datamart as a source.

If your datasets originate from SQL Database or other supported DirectQuery sources, you can configure your datamart to query those sources directly instead of importing the dataset. You can check the following link:

Create reports using datamarts (preview) - Power BI | Microsoft Learn

How to Get Your Question Answered Quickly 

Best Regards

Yongkang Hua

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

[lbendlin · Accepted solution]

Datamarts are lipstick on a dataflow pig.  They come BEFORE a dataset, and cannot consume one.  You can trick the pig by importing from an SSAS source but that would be mean.