Status:
Needs Info
Datamarts: Cannot load a table from a datamart into a Dataset.
Trying to use Datamarts as a cache layer for a couple of models. 1. A table with 20mln rows loaded into Datamarts from a Dataflow without any issues. 2. Trying to load the table into a model ...
Anonymous ,
Sure.
1. Create a Datamart and load a table from a Dataflow.
2. Refresh the Datamart.
3. Copy the Connetion string from the Server settings of the Datamart settings.
4. Create an empty dataset in Power BI Desktop. Get data from a SQL Server using the connection string from step 3.
5. Try to load the data into the Dataset. This step does not work.