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. 

rohit_singh's avatar
rohit_singh
Solution Sage
4 years ago

Hi Anonymous ,

Please open the power query editor and navigate through the steps for each of the queries where there is an error. Most likely the file is not in the correct excel format. Please share screenshots of the error in power query.

Kind regards,

Rohit

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?