Smartsheet to Power BI (adding a column)

[danishaomar]

Hi Guys, 

I use Smartsheet as my input to PowerBI. I have a report that is up and running for a few months now and its working completely fine. I would now like to afdd another column - from memory when I tried doing this last time around POwer BI did not detect that column and infact it messed it up a bit. So I just want to know what is the best way to add a column. 

I tried creating a card for a staticnumber but couldnt figure out how to do that either. I just want to add a card that says the completion rate in 80%. 

Is there any way I can add the above by the way of adding column or by adding a static card?

Would appreicate any help in this regards?

Dan

[v-deddai1-msft]

Hi @danishaomar ,

Based on my test, you can download the pbix file from power bi service and refresh the data from power bi desktop. Re-publish the pbix file to power bi service .

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai

[StefanoGrimaldi]

hey, you didnt  provide enought information to be able to help, show your M code before and after adding the new column, the error you getting and some dummy data of what you have and what you need to be added.