Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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  ...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    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. 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Thank you for your response Rohit. 

Here is the error i get under the power query editor 

 

But when i tried refreshing each table under Report (Field) - they all refreshed fully. 

rohit_singh's avatar
rohit_singh
Solution Sage
4 years ago

Hi Anonymous ,

Thanks for that. Could you click on the sheet 1 query and try refreshing in Power query like below :

I see that you've mentioned you have two sources of data from excel. Are all the ones showing errors from the same source?

Kind regards,

Rohit

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Yes, all those with the error are from the same source (Excel file) and Sheet1 is another source (Excel File)

    • rohit_singh's avatar
      rohit_singh
      Solution Sage
      4 years ago

      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?

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Thank you for your help, Rohit. Just got it fixed.