Forum Discussion
luxpbi
Helper V
Helper VPower BI Desktop Extremely Slow
Hi, The fact is that I have a not very big pbix. It's 32MB size. I've create a calculated column, a little bit complex, but it works. The problem is that since then the pbix is extremely slow, for...
Kumail
Impactful Individual
Impactful IndividualJust figured that file upload option is not available here.
May be you can contact on my email id for file or any other option to share you the file.
Regards
KumailImpactful Individual
Impactful IndividualTestDays =
VAR CurrentProduct = 'Table1'[Product]
VAR CurrentState = 'Table1'[Status]
VAR CurrentDate = 'Table1'[Date]
VAR CurrentNMov = 'Table1'[Index]
VAR CurrentCodTaller = 'Table1'[Type]
VAR NextStateDate =
CALCULATE (
MIN ( 'Table1'[Date] ),
KEEPFILTERS ( 'Table1'[Status] <> 8
|| 'Table1'[Status] <> 9 ),
FILTER (
'Table1',
'Table1'[Product] = CurrentProduct
&& 'Table1'[Date] >= CurrentDate
&& 'Table1'[Index] > CurrentNMov
&& ( 'Table1'[Type] = BLANK () || 'Table1'[Type] <> CurrentCodTaller || 'Table1'[Type] = CurrentCodTaller )
)
)
VAR LastMov =
CALCULATE (
MIN ( 'Table1'[Date] ),
FILTER (
'Table1',
'Table1'[Product] = CurrentProduct
&& 'Table1'[Date] >= CurrentDate
&& 'Table1'[Index] > CurrentNMov
)
)
RETURN
IF (
ISBLANK ( LastMov ),
( TODAY () - CurrentDate )
+ 1,
( NextStateDate - CurrentDate )
+ 1
)Even in measure, its working perfectly fine; as fast as any other feature in power bi
luxpbiWorks fast because of the size of the dataset. When you have 2 million rows is veeeery slow..
Do you think is there a way to optimize it?- Kumail
Not sure. Actually I was extremely busy on something therefore, couldn't reply you yesterday.
I have used python for my clients for processing large dataset and created a csv or excel file for visualization (If you are not querying data directly from CRM). That generally works well for me.