Forum Discussion
Data set files not matching
Hi there - not sure what's going on, i have 2 dataset from 2 excel files that i generated with R and feed to PowerBI. After updating with R today, and to refresh my Power BI - I get the error below ...
It was due to my R code used in generating the source files. Files needed to be opened and resaved as Genral due to security.
Yes, all those with the error are from the same source (Excel file) and Sheet1 is another source (Excel File)
Okay thanks. Would it be possible for you to send across the issue excel file and the pbix? If not then could you send me the full filename of the excel with extension and your M-code from the advanced editor for one of the queries, say adminleave factor?
Thank you for your help, Rohit. Just got it fixed.
Happy to hear that Anonymous ! Please mark this thread as solved and add a solution, if you might have one.
Kind regards,
Rohit
Appreciate your kudos! 😊