cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SamualDaxter
Frequent Visitor

Value cannot be null. Parameter name: stream

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

13 REPLIES 13
rahulshevde
Microsoft
Microsoft

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

Thanks Rahul. That helped!

rahulshevde
Microsoft
Microsoft

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 

I've the October release and the problem persists.

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. 

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.

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
Advocate I
Advocate I

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.

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" 😒

RicoZhou
Community Support
Community Support

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
Super User
Super User

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


@ me in replies or I'll lose your thread!!!
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Learn Power BI 2nd Edition
amitchandak
Super User
Super User

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



Power BI Features || Datamarts: https://youtu.be/8tskWsJTEpg || Field Parameters : https://youtu.be/lqF3Wa1FllE?t=70
Time Intelligence Decoded : https://youtu.be/aU2aKbnHuWs&t=145s
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!
Dashboard of My Blogs !! Connect on Linkedin !! Subscribe to my youtube Channel !!
Want To Learn Power BI | Beginners !! Advance Concepts !! Power BI For Tableau User !!

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



Power BI Features || Datamarts: https://youtu.be/8tskWsJTEpg || Field Parameters : https://youtu.be/lqF3Wa1FllE?t=70
Time Intelligence Decoded : https://youtu.be/aU2aKbnHuWs&t=145s
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!
Dashboard of My Blogs !! Connect on Linkedin !! Subscribe to my youtube Channel !!
Want To Learn Power BI | Beginners !! Advance Concepts !! Power BI For Tableau User !!

Helpful resources

Announcements
August 1 episode 9_no_dates 768x460.jpg

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power BI Dev Camp Session 24 without aka link and time 768x460.jpg

Ted's Dev Camp - July 28, 2022

Watch Session 24 of Ted's Dev Camp along with past sessions!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Top Solution Authors
Top Kudoed Authors