Forum Discussion
Authenticating Excel Workbook File - Semantic Model not refreshing due to invalid credentials
Looking at your screenshot, if it's the source you have open, it source starts with C:\, which means it's your local computer - that's why it wants to use a gateway/Windows auth. You may have that folder synced up to SharePoint, but Power BI is looking for it locally. You can update the path it's looking at to the SharePoint path to fix (you won't need a gateway if it's Online) - I have a video on how to do that here if it helps.
In your Excel file are you using a Table or just the Excel sheet as is? Because if you have defined a specific Table within the Excel spreadsheet then any columns or rows you add to that Table PowerBI is able to recognise. I read somewhere that if you are using Excel as a data source for PowerBi to always use tables so you can define the Column names and the Table area for PowerBi to "read".
Thank you for your help, it is a table but everytime I refresh the semantic model it does not add the new column. In excel 365 I even selected all columns and re-formatted as a table but it is still not picking up the new column