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.

Microsoft PowerBI

James Penner
edited 12/09/19 in Archived 2016 Posts

Hi All,


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.


This discussion has been closed.