-
Power BI + Smartsheet: Use Cases and Lessons Learned
I have recently started experimenting with the Power BI integration using the Smartsheet app: Smartsheet Power BI App In our EPMO, Smartsheet is our primary PPM tool, and I am now pulling that data into Power BI to explore more advanced analytics and drill-down reporting. I am interested in where Power BI still adds the…
-
PowerBI Connector and Reports - Visuals Stop Working after Gateway-side Refresh of Data
Context: I worked on a dashboard that's pulling dozens of sheets and merging them together into a dataset. It's time-consuming to add each Sheet to PowerBI and requires many manual steps. I've explored using a Report as it can automatically pickup new sheets automatically, adds the sheet name, etc. When I import into…
-
Adding a Table Widget to Smartsheet Dashboard similar to one in Power BI
So, here is the idea in Power BI we have a table widget which will show the required data we want. I know in Smartsheet we can make use of report for the same but why I am suggesting this is that instead of creating reports for every small piece of data to be shown on dashboard is kind of annoying so if we get a table…
-
Creating lookups through control center
Hello, I believe there is a way to do what I am asking but I am just unsure how to accomplish this task. Currently in control center we have a "revenue template" and some of the data that needs to be in this sheet has to be exported from Power BI and currently we are coping and pasting the data into the revenue template…
-
Need To Be Able To Connect Power BI To Datatables
There is a need for Power BI to connect to Datatables in Smartsheet. Currently, Power BI only connects to Grids and Reports. In order for data from a Datatable to be accessed, a workaround must be used. One common workaround is a Datatable feeding into Grids, and then Power BI can access the individual Grids. This requires…
-
Approval links that can be embedded in other applications
I know a unique link is created with each approval request (example in image below). It would be nice if this link could be made available for reuse outside the approval email and it would enhance the cross-platform functionality for Smartsheet based solutions. When links are created, they could be added as a new row in a…
-
Data Shuttle to Power BI
I am working on a project for a client, where they want to have dashboards built out for data analytic purposes that update automatically. The client already invested money into data shuttle, so data is automatically going to pull from the different data sources. Given that Smartsheet dashboards have limited analytics…
-
PM III Opportunity at Centene Corporation
Hello Smartsheet SME's — Centene is hiring for a PM role that will be expected to dedicate half their time to developing, managing, and integrating Smartsheet (using control center) with our PMO Portfolio level PowerBi dashboards. Please see below for a link to the external job posting and/or apply if you are…
-
Is it possible to input data into PowerBI that feeds into SmartSheets?
We have a PowerBI report which pulls from a SmartSheet sheet. My users want to be able to update the SmartSheet task from within Powerbi, such as being able to add a new comment in. Is this possible?
-
(500) Internal Server Error - Power BI
Hi All, I use Smartsheet as a data source often in Power BI. For the last two years I have never had an issue with Smartsheet's API, but today I have been getting a "Web.Contents failed to get contents from <insert smartsheet URL here> (500): Internal Service Error. Is this happening to anyone else? Or is this just a me…