Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
DebbieE
Community Champion
Community Champion

Imported Data in Power BI Taking a long time to publish / Display on Screen

Ive connected up to the Adventureworks DW to give a demo pf Power BI. The pbix file i 317097 kb

 

The Fact table contains 11,669,638 rows.  Is there anything I can do to speed things up. I have to wait ages moving from the dashboard to the report. And I wont be able to publish in the demo because it takes way too long

3 REPLIES 3
v-danhe-msft
Employee
Employee

Hi @DebbieE ,

Based on my research, if you want to improve the performence, I suggest you use direct query or live connection and you could refer to below blog:

http://radacad.com/directquery-connection-in-power-bi-how-does-it-work-limitations-and-advantages

 

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi I have the same issue here I tried to import the adventureworks database from SSAS tabular 2016 but eventually got out of memory exception.

I even tried to reduce the import to only three tables less than 5k rows in total and this how much memory is used for 5k rows !

Capture.PNG

Any thoughts?

I think I found why import uses a huge amount of memory.

I ran ssas profiler to capture the runing queries when importing data and this is what queries the SSAS engine executes to retrieve the data:

For some reasons it seems to do a crossjoin between each column which leads to an exponentiel number of rows and rapidly generates an out of memory exception.

 

Has someone ever experienced such behavior before?

SELECT
{
[Measures].[Days Current Quarter to Date],
[Measures].[Days in Current Quarter]
}ON 0,
SUBSET(
//There were another 100 crossjoins here which I removed for the sake of readability
NONEMPTY(
CROSSJOIN(
CROSSJOIN(
CROSSJOIN(
CROSSJOIN(
CROSSJOIN(
CROSSJOIN(
CROSSJOIN(
CROSSJOIN(
CROSSJOIN(
CROSSJOIN(
CROSSJOIN(
CROSSJOIN(
CROSSJOIN(
CROSSJOIN(
CROSSJOIN(
CROSSJOIN(
CROSSJOIN(
CROSSJOIN(
[Customer].[Address Line 1].[Address Line 1].ALLMEMBERS,
[Customer].[Address Line 2].[Address Line 2].ALLMEMBERS
),
[Customer].[Birth Date].[Birth Date].ALLMEMBERS
),
[Customer].[Commute Distance].[Commute Distance].ALLMEMBERS
),
[Customer].[Customer Alternate Id].[Customer Alternate Id].ALLMEMBERS
),
[Customer].[Customer Id].[Customer Id].ALLMEMBERS
),
[Customer].[Date of First Purchase].[Date of First Purchase].ALLMEMBERS
),
[Customer].[Education].[Education].ALLMEMBERS
),
[Customer].[Email Address].[Email Address].ALLMEMBERS
),
[Customer].[First Name].[First Name].ALLMEMBERS
),
[Customer].[Gender].[Gender].ALLMEMBERS
),
[Customer].[Geography Id].[Geography Id].ALLMEMBERS
),
[Customer].[Last Name].[Last Name].ALLMEMBERS
),
[Customer].[Marital Status].[Marital Status].ALLMEMBERS
),
[Customer].[Middle Name].[Middle Name].ALLMEMBERS
),
[Customer].[Name Style].[Name Style].ALLMEMBERS
),

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors