Nullable object must have a value error in Power BI Report Builder

[duncfair]

There are no NULL values in the dataset returned by the stored procedure.  What is the problem?

Also, why isn't there a separate Forum for Power BI Report Builder? 

[duncfair]

How about a decent tutorial that can help walk someone who uses Power BI Desktop every day to learn how to use Power BI Report Builder?

[pborah]

Hey @duncfair , I wish there was a separate forum or section for paginated reports but I try to work around it. As for your issue, without looking at your storeproc code, it's hard to tell. What executes perfectly in SSMS doesn't always execute the same way over on Report Builder side. If it's you who wrote the code, can you please share it? If you can't, then can you run a query profiler on your end? Usually issues like these have to do with how you setup your columns in SQL, specifically data type mismatch like trying to convert a null value into an int, etc. Hope that helps to some degree. 

[duncfair]

It is a simple stored procedure that uses a text value parameter to return a row of data. The parameter matches on a varchar datatype column in the table, and is defined as varchar within the stored procedure and as text in the Report Builder. Also, there is no query profiler that I can find within Power BI Report Builder (am I missing something?).

The query\stored procedure works fine and returns data as intended when I am in the design mode, but I immediately get the error above when I go to 'run' mode.