Sharepoint list data doesn't appear when you publish report

[Syndicate_Admin]

Good afternoon everyone, I have a topic, I have a report within power bi desktop, I have many data sources, one of them is a sharepoint list, inside my power bi desktop dashboard I can visualize the information that my dax gives me

But at the time of publishing the report, I no longer see data within that measure:

I checked permissions, data sources, and it seems everything is correct, any idea why this could be happening?

I thank you.

[Syndicate_Admin · Accepted solution]

Well for all those who at some point face something similar, I managed to solve it, I share with you what happened.

It turns out that when I create the data source within power bi desktop, there's a column that I use in my DAX that validates if the value is TRUE and counts it,

, but, when analyzing the data from that source within the power BI service, there are no values as TRUE or FALSE, if you don't see them as -1 for TRUE, and 0 for FALSE, that's why my DAX didn't count anything:

I modified my measure, putting in an IF(ISBLANK, so that if it doesn't give anything when validating TRUE, then I validated that field as -1, that way, I have the result either in POWER BI DESKTOP or within the POWER BI service in the workspace.

I hope I can help someone else.

Best regards.

[parry2k]

@Syndicate_Admin does it happen after you refresh the data in the service?

[Syndicate_Admin]

When I publish the report to the workspace, it's the only measure that doesn't appear as it is as I can see it within Power BI Desktop.

Everything is updated well, in fact, when I analyze the data within Power BI already in the workspace, and I go straight to that source, if I see the information, but my measurement is the one that is not seen, it is very strange, strange, and I want to become a monkey.

This is my DAX, which within power bi desktop does show me the measurement, which is 4

And within my area of work, if I analyze that origin I do have information, but it is already blank in the report:

My dax totals the 4 that you see from April, and in the power bi desktop you can see it, as in the image I put when I opened my query, but as you can see, when I see it published it doesn't show the result of the measurement.