Forum Discussion
Fetching live data from Excel
Hi Hrishikesh_M ,
Sorry, the connection from Power BI to Excel only supports import mode. If you want to always viewing current data, you can try to connect the data in SQL Server from Power BI. There is a DirectQuery connection mode, you can learn about it.
Power BI data sources - Power BI | Microsoft Docs
Use DirectQuery in Power BI Desktop - Power BI | Microsoft Docs
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hrishikesh_M , In the case of excel you have to schedule refresh that min 30 Min in case of Power bi Premium.
Or check out if streaming dataflows can help- https://docs.microsoft.com/en-us/power-bi/transform-model/dataflows/dataflows-streaming