Smartsheet and Microsoft Access

[Anonymous]

Hello,

I try to get data from Smartsheet and PBI offer a connection without fees.
For my project, I would like modify Smartsheet data in Access, because I have other data in an Oracle DB. This operation, for me, is easy to develop in VBA, but with my Smartsheet licence I can connect Smartsheet via ODBC.
My question is:
How PBI can connect a Smartsheet data? Can I use the same way to read this data via VBA without ODBC and without the classic export/import operation?
Thanks.

[v-yuezhe-msft · Accepted solution]

@Anonymous,

Power BI Service provides Smartsheet content pack, which offer you pre-built dashboard and reports, you can use it to connect to your source. Also you can use the SmartSheet connector in Power BI Desktop to connect to your source and build customized reports, then publish the report to Power BI Service.

Power BI doesn't concern about that how you modify the data in your original source, you can set schedule refresh for your dataset in Power BI Service, this way, when you have changed data in the data source, Power BI Service will automatically bring the new data to your dataset based on the schedule.


Regards,
Lydia