I’m asking for your help. I know that I can do incremental refresh in premium version but I came to the point that first I need to convert the date format „YYYMMDD” into power query on datetime with function (x as datetime) =>
Date.Year(x)*10000 + Date.Month(x)*100 + Date.Day(x).
Unfortunately I can’t handle it. Please help me how to do it. I attach an pbx file with a sample of csv data.
Sample pbx & data csv: https://drive.google.com/open?id=1axHPdzkikQ-NvmFhcnTmm9_dTKSjQZb8