Forum Discussion
Connection between an excel document and Power BI report
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?
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/
2 Replies
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/Thank you very much. I realized that just now and used an Azure SQL Server database. Thank you for your reply.
