Import Smartsheets to Microsoft Power BI and keep card view row order.
Hello All,
My goal is to pull the Smartsheet's data base and keep the card view order of my IDs. It seems as of now When I import it it give me row order instead of card order.
Example
ID order:
5 -> Multiple rows of data
3
2
etc..
Would need my table visual in power bi to keep that order. If the cards in Smartsheet's is changed, the next scheduled update I would want the table to update accordingly.
Is this a feature I can implement?
Best Answer
-
There currently isn't a way to pull the card order via the API; the order of data will be based on the Grid View row order, as you've found. Please submit your feedback to the Product team by filling in this form, here!
Thanks,
Genevieve
Need more information? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao!👋 | Global Discussions
Answers
-
There currently isn't a way to pull the card order via the API; the order of data will be based on the Grid View row order, as you've found. Please submit your feedback to the Product team by filling in this form, here!
Thanks,
Genevieve
Need more information? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao!👋 | Global Discussions
-
Thank you for the response!
Having Smartsheet connecting to power BI is a gamer changer already and very excited to be able to use. If there is ever a time where we could get the card view to line up as smart sheets shows it is next level gamer change for the field I am in.
Thank you for your quick response.
Jacque Trahan
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.2K Get Help
- 431 Global Discussions
- 152 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 74 Community Job Board
- 501 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 306 Events
- 36 Webinars
- 7.3K Forum Archives