Forum Discussion

Nicci's avatar
Nicci
Helper I
2 years ago
Solved

Refresh Issues After Publishing

Hi All, I have a very strange issue. I have a visual that is a table with information from 2 seperate databases on the same server. When setting up the data model I've connected via SQL server and m...
  • lbendlin's avatar
    2 years ago

    Hover over the visual in the service and validate the filters that are applied. Something in those filters prevents your data from showing.

  • Nicci's avatar
    Nicci
    2 years ago

    Thank you, that is exactly what happened. One of my filters was a true/false column that i converted to text it seems and the filter was = true, but when it published it retained the filter to = true, but after a refresh the other options were 0 and 1 (binary data type). So I had to readjust the column back to true/false and lock that filter and now it works great!