Get files from Sharepoint but Not importig All Files (most recent not showed)

[carlosam]

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...

[v-yuezhe-msft]

@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]

Thanks Lydia, my version is update July2018 | All files first upload to SharePoint folder and after refresh or create new query. This same problem have in Excel Get&Transform.

[v-yuezhe-msft]

@carlosam,

What do you mean "All files first upload to SharePoint folder and after refresh or create new query"?

Regards,
Lydia

[carlosam]

Upload is Save on SharePoint, and work on mine queries in Power Bi and Excel.
Reviewing this morning and continue the failure

[v-yuezhe-msft]

@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

[carlosam]

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

[v-yuezhe-msft]

@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