There is a need for Power BI to connect to Datatables in Smartsheet.
Currently, Power BI only connects to Grids and Reports. In order for data from a Datatable to be accessed, a workaround must be used. One common workaround is a Datatable feeding into Grids, and then Power BI can access the individual Grids. This requires multiple Grids to hold the data, and the same amount of Power BI connections.