Forum Discussion
New data in sharepoint folder not reflecting
Community SupportHi Anonymous
Sorry, I am a little confused, "Files are shown in edit query mode. But, the data is not getting reflected to dashboard. ", which power bi tool in using? desktop or service?
If in the desktop, make sure you've refreshed the data and there's no error prompted. also, Here's a typical workaround:
please create a new pbix file and clear the Permission the data source of SharePoint you used before under Edit Queries>> Data source setting>>Global Permissions>> find the sharepoint source >> Clear Permissions.
Reload the data. Combine then if needed: https://powerbi.microsoft.com/en-us/blog/combining-excel-files-hosted-on-a-sharepoint-folder/
Dear v-diye-msft,
I have linked sharepoint folder, it is reflecting in view (Please check click on right side pane)
"2020_Adhesives" is the new file shown in file list view
Data is not reflecting in excel data, (please check click on right side pane)
How to make data from new file 2020 to show in "observation view"??
- trebgatte
Most Valuable Professional
See my blog post and video on working with Excel in SharePoint. https://marqueeinsights.com/how-to-merge-multiple-excel-files-with-power-bi/ This might help you see where things have gone wrong.
Hope this helps!
--Treb, Power BI MVP
