Solved: Re: parameter

Anonymous · ‎05-09-2021

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 -

Can anyone help me regarding the same?

amitchandak · ‎05-10-2021

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

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

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

Anonymous · ‎05-10-2021

@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 · ‎05-10-2021

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

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

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube