Thinkorswim excel data import in powerbi

[sacusa1]

Spoiler

Hello All,
I am looking to import excel live data from think or swim. Data gets live updated in excel once you copy a file from TOS to excel. Data comes for example field =RTD("tos.rtd", , "LAST", ".NDXP220901C10000") then excel updates the file as we go. My question is how to get this same live data in powerBI? please suggest some options?

[lbendlin · Accepted solution]

If that Excel file is posted on a sharepoint/OneDrive then you can get near real time refreshes ("Within the hour").  If you need better than that then you can consider syncing your Excel file into something that you can have a direct query connection with (like a SQL server table)  or creating a process that pushes new data into a (hybrid) streaming dataset.