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
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.
Comments
-
Just following up as I have found the solution for this. In PowerBI desktop you need to select Edit Queries as per the below screen shot,
This does not affect the Smartsheet, only how BI queries the data.
-
Hi James-- Glad to see you were able to resolve this! Let me know if you run into any additional issues with the Power BI integration and I'll be happy to help
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 437 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
