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.
Β
Β
Β
Β
Β
Comments
-
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
-
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.Β