Forum Discussion
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...
HI PshemekFLK,
AFAIK, the current power bi does not support the refresh part of the dataset. Did you mean to work with a mixed dataset that used both cloud and on-premise data sources?
If that is the case, you can turn on the use gateway handle cloud datasource options. Then the gateway can handle this type of mixed dataset. (the excel file which you put on onedrive will use onedrive refresh and update hourly)
Use OneDrive for Business links in Power BI Desktop - Power BI | Microsoft Docs
Merge or append on-premises and cloud data sources - Power BI | Microsoft Docs
Regards,
Xiaoxin Sheng