parameter

[Anonymous]

Greetings,

I am trying to make parameter of 100 million to 200 million.

But it's not taking in the what if parameter. its showing me below error -

But it's not taking in the what if parameter. its showing me below error -

Can anyone help me regarding the same?

[Anonymous]

@amitchandak , I have another query...that is 

SQL View to Power BI Data type issue

1. Why NULL at SQL View is getting marked as blank, emply, etc. in power Bi

2. Binary data type ( 0 and 1) is getting converted either (True , False) / (1, -1) in power Bi

Is there any suggestion for the same? This is something very important that needs to be fixed!

[amitchandak · Accepted solution]

@Anonymous , It needs 100 million rows. Seem like the desktop ran out of memory. Please increase virtual RAM and increase the allocation of memory to power bi and try again

Check reply 7

https://www.pbiusergroup.com/communities/community-home/digestviewer/viewthread?MessageKey=6cd37af6-e634-4497-afb8-20e7e9ddaf26&CommunityKey=b35c8468-2fd8-4e1a-8429-322c39fe7110&tab=digestviewer

https://windowsreport.com/memory-error-allocation-failure/

[Anonymous]

@amitchandak , thank you. Its working now!