Forum Discussion

bgreiner's avatar
bgreiner
Frequent Visitor
2 years ago

Dataset in Report Builder returns NULL for values in certain fields

Hello. I have built a query for a dataset in Power BI Report Builder that is pointing at a semantic model in my organization's workspace. I built the query using the desktop program's query editor. I...
@Power BI Report Builder
RDL files
SSRS dataset
bgreiner's avatar
bgreiner
Frequent Visitor
2 years ago

Update: I still don't know exactly why this query construction fails when built in the desktop app, but I'm fairly certain it is related to the bracket characters ("[" and "]") in the field name. 

The workaround that I found was to open the .rdl files in Notepad, then copy the dataset definition from the file where it works to the file where I need it, then alter as needed. Hopefully that is helpful if anyone finds this post in the future with a similar problem. 

  • Ashley_J's avatar
    Ashley_J
    Frequent Visitor
    2 years ago

    I am also working on a report in Report Builder desktop which is connected to a semantic model in a Power BI Service workspace.  I had one column that was returning a null value in the Report Builder query, but displayed the data in Power BI reports.  The field name for this column used brackets [ ] as well.  Renaming the field name to remove the brackets in the semantic model resolved the issue for me.  You saved me a lot of frustration!