Forum Discussion

danishaomar's avatar
danishaomar
New Member
5 years ago

Smartsheet to Power BI (adding a column)

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

Need Help
Show and Tell

2 Replies

  • StefanoGrimaldi's avatar
    StefanoGrimaldi
    Resident Rockstar
    5 years ago

    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. 

  • v-deddai1-msft's avatar
    v-deddai1-msft
    Community Support
    5 years ago

    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