Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
I just started using the data connector for Power BI and it is pretty slick. The one problem I'm having is that in smartsheet columns are formatted as text/number but can't be defined as a number only, power BI does not recognize these fields as numeric so it can't perform additional calculations on the data such as sum, average, etc.
Has anyone found this with any of the other data connectors? Is there a workaround that doesn't involve exporting the sheet to excel?
Any thoughts would be appreciated.