Value cannot be null. Parameter name: stream

[SamualDaxter]

Hi Everyone,

I'm getting the following error when I open a pbix file in the August 2020 (2.84.981.0)

Value cannot be null.
Parameter name: stream

Is there any way I can get round this?

Is there a fix out there for this ?

It seems to be an issue with August's release, the dashboard was working fine in the July 2020 version.

Thanks for your help.

Andy

[rahulshevde]

I apologize for the incorrect date above. This was fixed in october and should roll out in the November release of desktop. 

Till then, as a workaround, you can try doing

File -> Options and settings -> Options -> Data Load (under global) -> Folded artifacts cache options -> clear cache

This should clear and regenrate the cache. (the error occurs when trying to read the cache.)

thanks

Rahul

[anvyas]

Thanks Rahul. That helped!

[rahulshevde]

This issue should be resolved in the November release. Please let me know if anyone encounters this after that. 

Till then, as a workaround, you can try doing

File -> Options and settings -> Options -> Data Load (under global) -> Folded artifacts cache options -> clear cache

This should clear and regenrate the cache. (the error occurs when trying to read the cache.)

Thanks
Rahul 

[moutinhoabreu]

I've the October release and the problem persists.

[rahulshevde]

Hey,

Yes i did add an updated comment with the workaround. 

I added incorrect date. the fix was made in october and should roll out in november release. Meanwhile you can try the workaround to unblock yourself. 

[moutinhoabreu]

Hi,

My source is a SQL on premises direct query, so it took me a while to open the data set. but...

The workaround you suggested it's working!!!

Thanks so much!!!

I'll wait for the November update for the final fix.

[anvyas]

I still see this issue in the October release. My version info is:
Version: 2.86.727.0 64-bit (October 2020)

Am i missing something?

Thanks

Anshuman

[bspillar]

Same here. Since last release. On a report with a streaming connection to a SQL database. The error message pops up continuously which prevents me from being able to edit any report settings.

[FrankPreusker]

I've upgraded to the September release of Power BI and do have the same issue in files with direct connections to an Azure SQL db: "Value cannot be null. Parameter name: stream" 😒

[v-rzhou-msft]

Hi @SamualDaxter 

Could you tell me if your problem has been solved? If it is, kindly Accept the helpful reply as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your data model and your problem. You can show me a screenshot about your issue.

Or share me with your pbix file from your Onedrive for Business.

Best Regards,

Rico Zhou

[Greg_Deckler]

@SamualDaxter You could check the Issues forum here:

https://community.powerbi.com/t5/Issues/idb-p/Issues

And if it is not there, then you could post it.

If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".

[amitchandak]

@SamualDaxter , check the know issues here -https://community.powerbi.com/t5/Issues/idb-p/Issues

[amitchandak]

@SamualDaxter , Are you able get any info on issues?