Visualizations not showing up when published to Power BI Service

[ACraig08]

I have a weird problem. I have several reports that I have uploaded to a workspace in Power BI Service that I had created in Desktop. This newest one that I have published in the workspace all of a sudden doesn't show the visualizations on all the pages. But some show and some don't. 

I have checked the other reports and they all work fine. I have checked the gateway connections and they all line up. I checked the data source permissions on all of the reports within Desktop and they all line up. I looked on the Dataset file on Server and the data all shows up. I even refreshed a different report within Destop and re-uploaded it to see if ended up having the same issue and it didn't. I am at a complete loss. I did run an update when I was creating this most recent report and is now running Version: 2.119.986.0 64-bit.

Just to add, when I upload the report at first it is fine. When I connect it to the gateway to refresh the data, that is when this issue appears to happen. 

Please Help!!

[Anonymous]

Hi @ACraig08 

Whether you add that data source to the gateway in Power BI Service and then configure the gateway on the dataset side, you can refer to the following link.

Add or remove a gateway data source - Power BI | Microsoft Learn

Best Regards!

Yolo Zhu

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

[ACraig08]

It turns out that it had to do with the boolean value created in Power Query Editor. In editor it comes out as a TRUE/FALSE value but when it was uploaded to the server and refreshed it changed them to -1/0. So the visualizations that I used those boolean values as filters were assuming there was no match so no data was showing up.