Forum Discussion
Missing last column in Power Query loading from .xlxs
Hello, I have a Power BI report that is fed by a SharePoint xlsx file. The xlsx file is updated via a Power Automate flow that saves the new updated file directly replacing it on SharePoint. Once Po...
Instead of connecting to the sheet, define your actual table in Excel and then connect to it by table name.
Hello,
this solution resolves the issue initially, but my setup overwrites the previous file with new updates every day, causing me to lose the table definition. I plan to create a Power Automate flow to generate the Excel table while updating data sources.
Do you have any insights into why this sudden problem has arisen? Nothing has changed in my setup for months, yet the issue began just a few days ago.
Thank you!
Can you pinpoint the exact date? May have been caused by a service version change.