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
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Shivu-2000 and thank you for the great answer!
But in this case, Power Query is really empty. There is no any data. I don't know 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". 

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!