How to link smartsheet sheets/ reports into Power BI WEB version

[adiperri]

I am on a Mac, therefore I am not able to download the desktop app. On the web version, I can not figure out how to connect a single sheet or a report to PowerBi. I am trying to use the AS Timeline Visual and have the choice between choosing from a report or a sheet. Right now it is just creating one massive report from all of my sheets and not even showing the reports. Newbie here and I am at a loss! 

[Anonymous · Accepted solution]

Hi, @adiperri 

Thanks for @ray_aramburo reply. If you want to link sheet/report in  Power BI Service, you can follow the steps.

Step1: Create a custom workspace

Step 2: Enter the workspace, and click Upload.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[ray_aramburo]

Depending on the structure of your sheets you would need to write a similar code like this in the advanced editor (open a Blank Query):

let
    Source = Smartsheet.Tables(),
    #"MasterBoardID" = Source{[Key=" MasterBoardID"]}[Data],
    #"FolderID" = #"MasterBoardID" {[Key=" FolderID "]}[Data],
    #"SheetID" = #"FolderID" {[Key=" SheetID "]}[Data],
in
#"SheetID"