I get a "bad request" error when trying to link a smartsheet report to Power BI?

Steve Tauer

Is it because there is a link to the sheet within the report results.

DataSource.Error: Web.Contents failed to get contents from 'https://api.smartsheet.com/2.0/reports/4021593383954308?pageSize=500' (400): Bad Request

Details:

  DataSourceKind=Smartsheet

  DataSourcePath=Smartsheet

    Url=https://api.smartsheet.com/2.0/reports/4021593383954308?pageSize=500

Genevieve P.

Hi @Steve Tauer

It may depend on what type of Report you're using - if you're using a Sheet Summary Report than this 400 error is currently expected since there is no API endpoint for Summary Reports. Please submit feedback to our Product Team about this, here.

You may also want to reach out to Microsoft to see if they can add the level parameter to the PowerBI call (see here), and you could also post in the Power BI Community to see if other users have come up with alternatives.

Cheers!

Genevieve