Forum Discussion

PshemekFLK's avatar
PshemekFLK
Helper IV
4 years ago

Real Time refreshed dashboard with Excel source

Hi,    I've been googling a lot on the topic but still not sure if I have the answer. Is it currently possible to have part of your model sourced from Excel file on the sharepoint and ability to se...
Need Help
PshemekFLK's avatar
PshemekFLK
Helper IV
4 years ago

Thanks for the answer Xiaoxin. 

 

Maybe I was not clear enough but what is most important for me is that part of dataset would behave as "Direct Query" (this option is not avaialble with Excel sources) so update immediately after refreshing visuals (not hourly) and the other part of dataset would be in "Import Mode" refreshed hourly. Basically I want to achieve a "Direct Query" with Excel source but since I know it's not possible I'm looking for a potential workaround?