Forum Discussion
Can't get single sheet data when using Smartsheet Content Pack
findbenwood,
By connecting to Smartsheet Content Pack, it is impossible to drill down the dataset to focus solely on one sheet as that in Power BI Desktop.
Based on your description, when you use Power BI Desktop to connect to Smartsheet, you publish PBIX file manually to Power BI Service each time you get updated data, right? You don't need to implement manual update, you can set schedule refresh for your dataset in Power BI Service after you publish PBIX file to Service the first time.
Regards,
Anonymous Hi there. I am having a similar issue reagrding SmartSheet single worksheet updates. I originally configured a SmartSheet worksheet as a data source for one of my reports. I did this in Power BI Desktop and then published the report to Power BI Pro/Service. I'd like to schedule a refresh on the SmartSheet data periodically. This post was helpful but I am not seeing the same "Connect directly" option under the Gateway Connection settings within Power BI Pro (service). Any thoughts? Did Microsoft do aware with this or am I just not looking in the right place? See screenshot below. Thanks!!
Hello everyone,
I have the same issue I couldn't find how to refresh sechedule with Smartsheet.
Please advice
Regards