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 Thank you for the help.

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.

Data set files not matching | Microsoft Fabric Community

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
  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
    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
Not applicable
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.