Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi! My query (PowerBI and PowerQuery) has to importing excel files from sharepoint folder, in both programs, not importing most recent files. Help with solution please...
@carlosam,
What version of Power BI Desktop do you use? Do you upload new files to SharePoint folder after you import data from SharePoint into Power BI Desktop? If so, please click "Refresh Preview" in Power BI Desktop to get the uploaded files.
Regards,
Lydia
@carlosam,
What do you mean "All files first upload to SharePoint folder and after refresh or create new query"?
Regards,
Lydia
@carlosam,
I am unable to reproduce this issue. Do you click "Refresh Preview " in Power BI Desktop?
Also please check if you can connect to the Excel file using Web connector in Power BI Desktop. The URL is like below.
https://xxxxxxxxx.sharepoint.com/sitename/Shared%20Documents/foldername/Excelname.xls
Regards,
Lydia
Lydia,
Connected with file RellenoAceites201808.xls and Working very well after download and run AccessDatabaseEngine_X64.exe
Not see the file when connect to folder
@carlosam,
I am unable to reproduce this issue. Please update your Desktop to August version, then re-connect to the SharePoint folder and check the issue.
Regards,
Lydia
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.