You can connect DirectQuery or live connection datasets to the data source. However, dashboard tiles pinned from reports that use DirectQuery still cache the data and refresh it in a defined frequency. Now, you can use the REST API for Power BI Embedded to set the cache refresh of a DirectQuery or live connection dataset.