Power BI

Has anyone used Power BI with Smartsheet?

I do a lot of things in Smartsheet, and we have another department doing things in Power BI. I see articles in Smartsheet about Power BI, but not sure what that means or if I have opportunities I should be investigating.

Find more posts tagged with

IT & Operations

Comments

Smartsheetchamp

I have used power bi with smartsheet.

we have specific business requirements for charting based on data. we used smartsheet for data collection and cloud-based excel functionality to our users.

we have integrated smartsheet with Power BI and generate nice and neat look charts for our executives for analysis/decision making. they loved with the presentation.

Good things are that integration with Power BI from smartsheet is sleek and one click.no Additional programming needed.

styless

Yes, I have linked my smart sheet data and turned them into powerBI report/visualization for the leadership thing.

Like what Smartsheetchamp mentioned, it is an easy one click to get the data source.

Bruce Case

Interesting! Any thoughts on now to get started. I know via Smartsheet, we can pay for a resource to help get things going, but hoping to see what it can do before making that investment.

Michael Scherotter

I have been able to load a SmartSheets Gantt Chart into Power BI Desktop and display it with the as Timeline visual but the sheet has groupings and the grouping hierarchy isn't in the data sent to Power BI - this is a big blocker.

Any suggestions?

Michael

Kelsey Miller

@Michael Scherotter was there ever an answer to this question? or were you able to solve it?

Sign in to join the conversation!

Quick Links

Trending discussions

Attachments with Widgets
I have a dashboard that has a report widget and I was wondering, can that widget also show the documents attached to a row so you can click on them or is that only in the sheet?
Is there a way to prevent a shared user from seeing the data in the "View Detail" option?
Is there a way to prevent a shared user from seeing the data in the "View Detail" option? I'm trying to make sure that when a user is given access to view a report, they can only view the columns present in that report. The view might only show certain columns but the user can then click on the record as shown below and…
Gantt Chart Timescale not aligning with projects fiscal year and start/end dates
I have a project sheet with a Gantt chart where the timescale headings are not aligning with my project’s fiscal year and start/end dates. Configuration: - Primary heading: Quarters (displaying as Q4 2026) - Secondary heading: Months (MMM format) - Fiscal year start: February 2 - Week start: Sunday - Project start date:…