Can you connect to a Smartsheet DataTable?

[LYBridges]

Has anyone successfully connected to a Smartsheet DataTable (not a report or sheet) using Power BI? DataTables don't show up using either of the Smartsheet connectors (Legacy or Beta). What method did you use to get/connect to the data?

My DataTable has over 70,000 rows, so can't be recreated as a sheet.

Any ideas or suggestions?

Thanks!

[LYBridges]

Thanks so much! I'm using multiple worksheets now. I'll have to see if an intermediate database works better. 

[v-xianjtan-msft · Accepted solution]

Hi @LYBridges 

It is recommended that you consider splitting the data into multiple worksheets. Alternatively, export the data to an intermediate database (such as SQL Server) and then connect to that database from Power BI.
In the meantime, you can also contact Samrtsheet for support to see if they have better insights. Smartsheet Support | Smartsheet

Best Regards,
Jarvis Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.