Report Builder - Data from the Query shows up as "Null"

[Anonymous]

Hello,

I am learning how to use Power BI tools. 

I have been experiencing a problem with Report Builder. 

I am working from a pbix file stored on a Premium Space. In PBI Desktop, I transformed the data, I can see the data on the visualizations. So in Desktop, everything is fine.

Then I used the method shown here (https://docs.microsoft.com/en-us/power-bi/paginated-reports/report-builder-shared-datasets) to get the datasource and create a dataset in Report Builder. 

Some of the data show up well in the request and in the report.

Some of the data show up well in the request, then show up only in "Page" mode when I execute the report (those in time format). 

And some of the data don't show up at all : the request returns a "Null" value. 

I guess that the problem is in the query but I can't find where. 

I noticed that most of the latest happen to be numbers, but there is no need for calculation nor transformation so they are in "text" format in Desktop  as if they were just a string of characters that need to appear on the report. I changed a few of them into number format but it didn't change anything. 

Thanks for your help. 

[Anonymous]

Hi @Anonymous ,

Not very clear.

If you want to change a column type which contains value of "Null" from Text to Number, please right-click the column --> Replace Values: "Null" --> null like this:

And then you could transform the data type to number:

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous · Accepted solution]

Thanks for your help.

This didn't work, but I tried creating a measure for each of these problematic columns. The measure was just the name of the column in order to "copy and paste" it. And it worked.