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 have no more ideas - I have tried to refresh semantic model in service, report in desktop and tried to Power Query (it shows Queries (0)). 

Please ask further questions if needed, just wrote what came to my mind about this problem.

Thank you in advance!

Need Help

9 Replies

  • 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

    So I tested one thing: I downloaded previous report (old one) and there the data source was "Smartsheet" -> I signed in and the added column appears there. But there is still a problem: How can I get it to my report (which I have edited and which has NOT "Table view". Or should I do all those changes and edits to old report and deploy it again to service dev and prod..? (In dev there is no semantic model, just report, in prod there are both).

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      I got access to Smartsheet and now I use it on my new report (Get data etc.). I created measures again (from Direct query table to this smartsheet one) and deleted old table (Direct Query, includes same columns but the added one). 

       

      BUT NEED HELP ONE MORE TIME WITH THIS:

      I have there other table also which is not in this same smartsheet. One visualization has been done from this table so it means it doesn't work when I publish it to service (since I have only this Smartsheet to other visualizations). Is there any option for example to copy table or table's columns to this other table? Or do you have any other ideas or solutions for this?

      Please, need fast asnwer if you have any and if possible ğŸ’– 

      THANK YOU!