-
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…
-
How do you avoid Power BI Semantic Model Error when column headers are modified (add/remove/edit)
For anyone connecting Smartsheet with Power BI and using sheets as sematic model, and set a scheduled refresh, you might have encountered errors where when a column has been modified, whether add or removed or renamed, the refresh is halted until. My usual fix is to download the PBIX and update source (Navigation) to…
-
Data Entry Suggestions for Siloing Data for Radar Chart
Hey everyone, I’m exploring the best way to use Smartsheet for collecting score card data and formatting it for a Radar Chart. Ideally, I’d like to: Enter audit results in Smartsheet Modify or structure the data in another sheet Format the combined data for visualization The goal is to merge audit percentages from the…
-
Merged: Connector for Smartsheet and Google Looker Studio
This discussion has been merged.