Forum Discussion
Power BI and Sharepoint does not refresh
Hi,
I connected Sharepoint file to Power BI, I worked, edited and etc.. everything was ok - everything is updatting.
Problem occured when i added additional sheets(CW__28, CW__29) to sharepoint excel, with info in it. New sheets does not refresh/appear nor in Power Querry nor in Power BI.
Can someone explain why is that?
Hello! When you create your pbix in the first place, you define which sheets you bring in. Power BI cannot just bring in new sheets without your manual intervention. What I would suggest instead is save each week as a csv and have each csv in a folder in SharePoint, then connect to the folder instead of an individual file and in Power Query when you expand the folder it will basically append all the files together. Then, each week, add a new csv to the folder and they will continue to be appended to the old data when you refresh - just make sure the field names are the same in each file in the folder.
1 Reply
- audreygerred
Super User
Hello! When you create your pbix in the first place, you define which sheets you bring in. Power BI cannot just bring in new sheets without your manual intervention. What I would suggest instead is save each week as a csv and have each csv in a folder in SharePoint, then connect to the folder instead of an individual file and in Power Query when you expand the folder it will basically append all the files together. Then, each week, add a new csv to the folder and they will continue to be appended to the old data when you refresh - just make sure the field names are the same in each file in the folder.