Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I am using the certified Smartsheet data connector to connect Power BI to Smartsheet (cloud solution). I am able to refresh the report fine from within Power BI Desktop. The problem comes when I go to create a scheduled refresh it says it does not recognize the Smartsheet connection as an external data connection. I've searched through all of the Power BI help (please do not link the unsupported data types as I am either missing something or it is not making sense) and I can't find why this shouldn't work.
From the screenshot below it looks like refresh from service is available... it says gateway is not required.
Am I missing something?
Solved! Go to Solution.
So the screenshot you are showing is from the Power BI Service (the cloud version) not from Report Server (the on-prem version)
Power BI report data sources in Power BI Report Server - Power BI | Microsoft Learn
Unfortunately SmartSheet (and most other cloud based sources) are not supported for scheduled refresh when using the on-prem report server. If you have a mix of on-prem and cloud based data the general advice is to publish your reports to a cloud based workspace and use a data gateway for the on-prem data.
So the screenshot you are showing is from the Power BI Service (the cloud version) not from Report Server (the on-prem version)
Power BI report data sources in Power BI Report Server - Power BI | Microsoft Learn
Unfortunately SmartSheet (and most other cloud based sources) are not supported for scheduled refresh when using the on-prem report server. If you have a mix of on-prem and cloud based data the general advice is to publish your reports to a cloud based workspace and use a data gateway for the on-prem data.
Wow that is unfortunate... thank you for the response though that makes sense.
User | Count |
---|---|
11 | |
9 | |
4 | |
1 | |
1 |