Forum Discussion

GarryFarrell's avatar
GarryFarrell
Icon for Advocate III rankAdvocate III
9 years ago

Reports not refreshing when files are replaced in folder source

I have a PBIX file (Power BI Desktop) that connects to a folder as the source. There are 100 files. When the data files are replaced I need to refresh the data. I did the following to get the data to...
Tips and Tricks
v-caliao-msft's avatar
v-caliao-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi GarryFarrell,

 

I have tested it on my local environment, we cannot reproduce this issue. I can refreh the data without any issues after replaced original datasource file.

 

Please provide us deital steps, so that we can try to reproduce this issue and make further analysis.

 

Regards,

Charlie Liao

GarryFarrell's avatar
GarryFarrell
Icon for Advocate III rankAdvocate III
9 years ago

Hi,

 

I have 100 files that all have 500 rows of data each. The transformations are significant to get the data into the correct shape for reporting. I'm reading the folder in as 3 sources and then joining them back together. When I close and apply 3 or 4 processes start called ...mashup which is Power BI processing the folder and the transformations. It takes about 20 mins to complete.