Connect MS Power Query to Smartsheet?

Can anyone explain how to connect Smartsheet reports to MS Power Query? I have tried creating API Tokens to connect some of my reporting, but I’ve been unsuccessful. I can “halfway” Access the Smartsheet via Power Query, but I’ve not been able to figure out how to access my content through Smartsheet and manage the data.

I’ve been using MS Power BI with Smartsheet for data modeling and visualization, which is very useful, but I’m also looking for a away to create some flat data through Smartsheet and refresh on an interval for share point reporting.

I’ve not yet figured out how to share a Power BI file “pbix.” with Smartsheet source data (my data model) that can provides team members within my organization the ability to refresh and pull real-time data in the file. The Smartsheet data model in the pbix file I created does not allow them to refresh the source data, so my goal is to attempt this though Power Query.

Find more posts tagged with

Sheets

Sharing and Collaboration

Reports

Importing and Exporting

Comments

PPS Solutions

HI, so we have created Power BI reports using Smartsheet data and then shared those reports via Power BI with other employees, it sounds like you are not having success with that, is everyone a Power BI user and shared to the Smartsheet data too?

Have you looked also at the Data Connector too?

Dan

JDupes

Hi Dan - Correct, I’ve not had success yet sharing PBI reports with Smartsheet’s source data, despite others being collaborators in Smartsheet or having a PBI license.

I don’t think data connector is an option on our plan.

Not sure what the next step is. Appreciate any added input you could share.

Sign in to join the conversation!

Quick Links

Trending discussions

Automation for Daily Reminders After X Days Past Due
I'm creating an offboarding checklist sheet which sends out automation notifications to relevant parties in each department. Notifications are sent out when the termination goes live, one week after the termination date (if that department's tasks still aren't checked off as done), and two weeks after the termination date…
Sharing sheets
Does sharing a sheet with edit or view rights immediately require the shared user to have a paid license, effectively making them a group member? This seems to be occurring. In contrast, can I confirm that sharing a link using the 'publish' feature will not require a license since the user is only accessing that specific…
Viewers and Permissions after new pricing model
I have provisional users who, under the legacy model, were unlicensed users with editing permissions for workspaces. I’ve now changed their role to "viewers" and assigned editing permissions to specific workspaces, aiming to maintain the same editing experience as before. However, they cannot edit fields within tasks or…