Hi,
I'm trying to connect an excel that located in SharePoint to be my query database in Power BI desktop.
After I connected the SharePoint excel file through "SharePoint folder" option, I entered to "Power query editor" and there I saw all the excel files that located in my SharePoint.
Therefore, the steps that I took were:
1. Search the specific excel file that I need in the list (in power query) and see its row number
2. Click on "Keep rows"
3. Click on "Keep range of rows"
4. Choose the row number from (1.)
5. Then, the only file that I have in the list is the file that I need.
Till now everything works fine. The problem is when I do changes in the SharePoint itself, for example add new excel file (that is not related to the Power BI), it changs the list of excel files in the "Power query editor" and as a result, the row number that I chose in (4.) is wrong (and of course that all the dashboard is a big error).
Is anyone can advise on other way to conenct to SharePoint excel or to fix my current way so the file selection will remain constant?
Thank you in advance
