Smartsheet DataSource Error - Bad Request

[joaopnascimento]

Hi Everyone,

I'm facing a problem connecting a Smartsheet report to Power BI.
I've seen this issue mentioned in several forums, but I haven't found a solution. For Smartsheet sheets, there is no problem, but for summary reports, this 'Bad Request' error always appears.

[v-jiewu-msft]

Hi ,

Please go to the smartsheet forum for technical support.

Best Regards,

Wisdom Wu

[vanessafvg]

this gives an explanation as to why its not working, apparently this is expected as the api doesn't work for summary reports.

https://community.smartsheet.com/discussion/73745/i-get-a-bad-request-error-when-trying-to-link-a-sm...

[joaopnascimento]

So, there is no solution? 

[vanessafvg]

it is not a power bi issue, it has to the do with api from smartsheet, as per the link i provided there is no api for the summary, maybe best to check in with smartsheets go to the link i provided and contact support, I  do not see any one else who has found a work around in power bi.

[joaopnascimento]

Thank you Vanessa. I will try to get a support from smartsheet.