Forum Discussion
Connection between an excel document and Power BI report
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/
Most Valuable ProfessionalHi 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.