Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Datamarts: Cannot load a table from a datamart into a Dataset.

Submitted by Anonymous on ‎06-05-2022 02:18 AM

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 in Power BI Desktop. Loading stops after several thousands rows. 

 

Checking the approach using SQL Server Managment Studio. A query can load the whole table without any issues.

 

 

Status: Needs Info
See more ideas labeled with:
7 Comments (7 New)
Comments
Anonymous
Not applicable
‎06-05-2022 10:21 PM

Hi @Anonymous 

When you create a datamart , system will also create a dataset , so I don't quite understang that you said "can not load a table from a datamart into a Dataset" . Can you describe your process in detail to me ? 

 

Best Regards,
Community Support Team _ Ailsa Ta

Anonymous
Not applicable
‎06-06-2022 12:55 AM

I do not need the Dataset created automatically in my scenario so I connect to the SQL database which is advertised as an important feature. 

Anonymous
Not applicable
‎06-07-2022 03:21 AM

@Anonymous What info do you also need?

Anonymous
Not applicable
‎06-07-2022 10:42 PM

Hi @Anonymous 

The second thing you mentioned, “Trying to load the table into a model in Power BI Desktop. Loading stops after several thousands rows“, can you describe the steps in detail ?

 

Best Regards,
Community Support Team _ Ailsa Tao

Anonymous
Not applicable
‎06-08-2022 12:11 AM

@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.

MrNobody
Frequent Visitor
‎11-06-2022 11:11 PM

@Anonymous 

 

I don't think this needs more detail. As @Anonymous has stated: When importing data from a Datamart into a Dataset in desktop, the import will fail after several thousand rows have been imported.

 

I suspect there is a limit on the number of cells that can be exported from a Datamart - and it is this that is the issue. Sometimes I can get it to import ~100K of rows, sometimes ~25K, dependant on table width.

 

It is sooooo super frustrating as I want to share datasets so users can use them to supplement models their building...

MrNobody
Frequent Visitor
‎11-06-2022 11:36 PM

@Anonymous 

 

Also, you get this message in the service if you try and refresh too much data.

 

MrNobody_0-1667806494146.png

 

NB: I was able to create this situation as i used a parameter to switch between full load, or first 1,000 rows.

Idea Statuses