Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

New fields not visible to users

Recently I've attempted to make some basic changes to a published report, but any of the new fields I add are not visible to users in the service, though they are visible to me. I've tested several f...
Data Protection
Need Help
Akah's avatar
Akah
New Member
2 years ago

Did you re-publish the report after update ?
What data source are you using ?
check for data source schedule refresh 

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Yes I've republished multiple times. The data source is a few different csv files. The normal, scheduled refresh occurs daily, and there have been no issues with the refresh with respect to the existing fields. 

  • collinq's avatar
    collinq
    Icon for Super User rankSuper User
    2 years ago

    HI Anonymous ,

     

    When you say you make changes - where are you making the changes?  And, are you sharing the APP or the workspace version of the report?  If you have made changes in desktop, published to workspace but not "update app" then the changes have not made it throught the process?  Same if you are changing fields online and not updating the app.

     

    If all that is true, go into Advanced Editor and make sure that there is not a "Columns = 'x' " type text in the string.  That sometimes happens.  The normal advice is to modify that number to the correct number of columns.  For me, AND NOT NECESSARILY RECOMMENDED, I always just delete that bit entirely because I don't want to deal with incrementing it.

     

    If that is ok, then go to the query editor, to applied steps, to source and make sure that "Choose columns" has all of the columns you are looking for.

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      I'm making the changes in BI desktop, and only the workspace version of the report is being shared. The fields are all pulling through in desktop, but in the service I'm the only one that can see these new fields. 

      • collinq's avatar
        collinq
        Icon for Super User rankSuper User
        2 years ago

        Hey Anonymous ,

         

        I understand that users in the Service can see other parts of the data but not this part.  I also understand that you do not have RLS turned on.  Do you have any sort of "privacy levels" set in the desktop?  (File - Options and Settings - Options - Edit Permissions)  And, do they match the version in the Service?

        Are the users looking at the report in the app?  If so, after making changes and publishing did you update the app as well?

        Is your version of Desktop quite old?  I am wondering about a mismatch between the Service version and the Desktop version.

        Are the new fields added to an existing table/query or are they a new query - and therefore, is the Data Source/Gateway connected to the new source?

        Do the new fields themselves actually have data in them - and do you have the "show items with no data" selected just in case?

        Are the new fields in a data source that is not in the gateway but needs user permissions and these users do not have permissions to that data?