Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Added column to data source doesn't refresh to report

I have done the report (downloaded old report from service and edited it) in Power BI Desktop. Now there have added column in data source (Smartsheet). How can I get this column to my raport too? I h...
Need Help
Idrissshatila's avatar
Idrissshatila
Icon for Super User rankSuper User
2 years ago

Hello Anonymous ,

 

when you go in power query and refresh the table the new column should show, unless you used the choose columns which just keep the column you choosed and remove everything else.

 

so in  this case you should edit the choose columns and pick the new column as well to appear.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Thank you for your response, but as I said there is no data when I go to Power Query, have no clue why. So can't refresh either. I'm not sure if there is something wrong with my data source (in data source setting it is "DirectQuery to AS" not "dataflow" or "smartsheet". 

     

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

      Anonymous ,

       

      then you're not reading directly from the sharepoint, you need to see from where you are reading and make sure the data is updated there.

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Ok, thanks. So if I understand correctly, I have to change data source from DirectQuery to Smartsheet (it was smartsheet in the report when I downloaded it from Service, but for some reason it isn't anymore). I am not sure if it is possible to do, because I haven't the link / access to this Sharepoint, isn't it? Or should I ask the owner/admin of Sharepoint to give link and access? What do you recommend, could you please give simple steps or say what should I do next? Thank you very much! 

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

      Anonymous ,

      This could be because you are reading from a different location while your data is at a different location. Pls. verify if the link that you are using in Sharepoint connector is properly referencing to the file in the sharepoint that you want to read

       

      Regards,

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Ok, thanks. So if I understand correctly, I have to change data source from DirectQuery to Smartsheet (it was smartsheet in the report when I downloaded it from Service, but for some reason it isn't anymore). I am not sure if it is possible to do, because I haven't the link / access to this Sharepoint, isn't it? Or should I ask the owner/admin of Sharepoint to give link and access? What do you recommend, could you please give simple steps or say what should I do next? Thank you very much!