Connection between an excel document and Power BI report

[LlaytonTitus]

How can I create a live connection between an excel document and my Power BI report so that when I update the excel document, my power BI report also get updated automatically when I refresh it?

[tackytechtom · Accepted solution]

Hi @LlaytonTitus ,

I think what you are after is direct query, which unfortunately does not exist for excel files:

DirectQuery in Power BI - Power BI | Microsoft Learn

Here an old thread that might give you some more details:

Solved: Direct Query for Excel Data - Microsoft Fabric Community

Let me know if this helps 🙂

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/

[LlaytonTitus]

Thank you very much. I realized that just now and used an Azure SQL Server database. Thank you for your reply.