Clicking Data in Power BI and getting to the Data Source in Smartsheet
I have a Smartsheet data set. This data was connected to Power BI. I want to be able to click on some data, for example, a specific project number, in Power BI and be taken to the Smartsheet row. Is that possible?
For instance, in Power BI, we used the data from Smartsheet to create a Top Ten list:
Clicking on this project only changes some of the other filtered items in Power BI. I want to click on the top project and have it open up the smartsheet row so I can look at additional information that we aren't using in the Power BI.
Answers
-
@Jenn W. we try not to leave smartsheet and add the powerbi as embed into the smartsheet dashboard in this way we can directly also register decisions meeting minutes in smartsheet . What do you think about this idea ?
If my comment helps you, I appreciate a 💡
Kind regards
Event: Strategies for Successful Adaption
Nico | LinkedIn
CEO | Lighthouse Consultings
Lecturer in Business Information Systems | DHBW
________________________________________________________________________________
addvalue@lighthouseconsultings.com
https://www.eventbrite.de/e/driving-change-with-smartsheet-strategies-for-successful-adoption-tickets-1047813557557?utm-campaign=social&utm-content=attendeeshare&utm-medium=discovery&utm-term=listing&utm-source=cp&aff=ebdsshcopyurlWe offer Licenses - Training - Solution Engineering
🔴Certified Smartsheet Partner _______________________________________________
💯 SCALEABLE Solutions Engineered by Lighthouse Consultings
We Don’t Just Implement Smartsheet; We Revolutionize How You Manage, Plan, And Execute.
-
Hi Nico,
Thank you for your response. So you are saying that we can create a Smartsheet data list, upload to Power BI, then take the formatted Power BI and put it back into a Smartsheet dashboard? There's no way to click on information in Power BI itself and be taken back to Smartsheet?
-
@Jenn W. you can embed a powerbi dashboard into a smartsheet dashboard.
https://app.smartsheet.com/b/publish?EQBCT=95ddb82f1bb04e7c97eb8fab1ebf3929
If my comment helps you, I appreciate a 💡
Kind regards
Event: Strategies for Successful Adaption
Nico | LinkedIn
CEO | Lighthouse Consultings
Lecturer in Business Information Systems | DHBW
________________________________________________________________________________
addvalue@lighthouseconsultings.com
https://www.eventbrite.de/e/driving-change-with-smartsheet-strategies-for-successful-adoption-tickets-1047813557557?utm-campaign=social&utm-content=attendeeshare&utm-medium=discovery&utm-term=listing&utm-source=cp&aff=ebdsshcopyurlWe offer Licenses - Training - Solution Engineering
🔴Certified Smartsheet Partner _______________________________________________
💯 SCALEABLE Solutions Engineered by Lighthouse Consultings
We Don’t Just Implement Smartsheet; We Revolutionize How You Manage, Plan, And Execute.
-
This is definitely possible - Power BI has a "URL" option, where you can make some data in table a clickable link. You need to set that value to the link of the specific row/sheet of interest.
One issue is if you use the built-in Power BI smartsheet connector, I don't know if you'll be able to get the URL you need. We use the API and can get the information from there, but haven't tried with the Power BI Smartsheet connector.
-
@Jenn W. did this help you ?
If my comment helps you, I appreciate a 💡
Kind regards
Event: Strategies for Successful Adaption
Nico | LinkedIn
CEO | Lighthouse Consultings
Lecturer in Business Information Systems | DHBW
________________________________________________________________________________
addvalue@lighthouseconsultings.com
https://www.eventbrite.de/e/driving-change-with-smartsheet-strategies-for-successful-adoption-tickets-1047813557557?utm-campaign=social&utm-content=attendeeshare&utm-medium=discovery&utm-term=listing&utm-source=cp&aff=ebdsshcopyurlWe offer Licenses - Training - Solution Engineering
🔴Certified Smartsheet Partner _______________________________________________
💯 SCALEABLE Solutions Engineered by Lighthouse Consultings
We Don’t Just Implement Smartsheet; We Revolutionize How You Manage, Plan, And Execute.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.1K Get Help
- 412 Global Discussions
- 221 Industry Talk
- 459 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 141 Just for fun
- 58 Community Job Board
- 461 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 299 Events
- 38 Webinars
- 7.3K Forum Archives