Forum Discussion
Create a datamart with multiple datasets
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
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.
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.
2 Replies
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.
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.