Pull Data from Power Bi to Smartsheet
Hi,
I would like to integrate Power bi with Smartsheet and pull the data on the tables on Power bi to Smartsheet.
Is there a way to make this connection ?
The reason i need to do this is to make my employee see the data through Smartsheet not from Power bi.
Thank you.
Answers
-
Hi @YBnf
One way to get the data into Smartsheet would be to Export your Power BI data into an excel file, see: Export the data that was used to create a visualization
Then you can import that into Smartsheet to create a new sheet, or if you have access to Data Shuttle, automatically bring that content into a current sheet.
I hope that helps!
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
**Sorry, just realized that you wanted the other way around - and I cannot delete the comment.**
There is now a Smartsheet connector in Power BI. If you go to "Get Data" and search for 'Smartsheet' you will see a Beta connector for the Smartsheet application. Assuming you have Admin permissions, you should be able to pull data from sheets and reports into Power BI.
This has been working successfully for me regarding Row Reports, however I am having issues importing data from Sheet Summary Reports. I just submitted a ticket with Smartsheet to review
.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives