Something to do with newer files? Doesn't make much sense to me. xlsx files to see if they appear but they do not. I would be open to modifying the connection if there is a way via the advanced editor, but I'm unsure where the reference to the specific file resides in the code.
Free Excel templates take the stress away from having to remember whose turn it is to clean the bathrooms or wash the dishes.
The Advanced editor code doesn't seem to use specific URL address either (i'm using the cobine & transform option). If youre looking for Excel templates to use at home, consider a weekly chore schedule or household to-do list.
I'm all out of ideas for workarounds to force the use of a Sharepoint file as a data source. xlsx files and it's just this particular one I need that is just not showing up. I have successfully connected to 4 other.
I have successfully added the workbook within the Power BI Service (hoping this would facilitate the connection process) and also verified that it is present in the Sharepoint directory (note: I do not want to target the file sitting on my local hard drive). xlsx file that does not appear in my list of available files from my Sharepoint Site. I am interested in targeting a particular. The original question from this post pertains to targeting a specific folder to connect to, so that all other files are not available. docx files - I cannot remove my write access to files as the report creator, which seems to be the only viable solution in this thread so far. xlsx files) and includes a huge number of other document types such as. Yet, Power BI Desktop seems to disregard some files (e.g. Yes, I can connect to the root directory of my Sharepoint Site. Excel doesn’t accept this information.This seems to be the ongoing query here, which is the issue I am experiencing.
Excel looks for certain patterns when processing data for Excel Power Map, and this can create limitations. Based on the work posted by Ken and others, I built a function to update a query by its name.