Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Anonymous
Not applicable

HANA view default parameter error in PBI "Value cannot be null"

I have a HANA view parameter  with a default value. when I open this HANA view with PowerBI it recognises the default value and showing in parameter screen but when I select any field its throwing an error message " Unexpected error: Value cannot be null".

 

Samething works in AFO (Analysis for Office)...Please advise if anyone faced this similar issue before and a possible solution. Thanks

 

-Sam

2 REPLIES 2
Anonymous
Not applicable

Hi @Anonymous,

 

Which version of power bi desktop you test? Can you please provide some detail information to help clarify your issue?

Regards,

Xiaoxin Sheng

Anonymous
Not applicable

I have the exact same issue with a default value in a variable from a HANA view. Is this issue solved?

 

When I clear the default option (and have no selections), I can import the data. When I make any chosen selection, the import dumps with the described message. Even if I adapt my HANA view and remove the default value, the parameter causes this issue during import of the data.

 

I'm on Version: 2.65.5313.841 64-bit (december 2018).

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors