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.
I need some help to a similar issue. I use to be able to create beautiful reports with PowerBi and link it to data in excel files on OneDrive which would refresh instantly. Now I can't do any of that - I linked a semantic model to an excel in my one drive and it says it refreshes but it actually does not refresh the data. I added a column to the excel file and it is not showing up after many refreshes.
What is the best way now to use data from an excel file on onedrive and build a report in powerbi service where if I make changes to the data in the excel file it will continue to update. I am so confused, some videos talk about a lake house and microsoft SQL , microsoft fabric. I honestly just want the report to be able to link to the excel file like it use to when we had data sets and update. I don't need a lakehouse.
Thank you for your help out there ❤️
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