Forum Discussion

Ayush_tiwari08's avatar
5 years ago
Solved

Power Bi Imported dataset is not working with R scripts showing error that object "Column" not found

Hello Everyone i need help urgently 

I have imported an excel file in power bi now i wanted to visualize using R so when i started working with R i am geeting an error that (object "Column" not found)  and the thing is column is successfully imported and when i created a manual data in R editior it is showing me plots successfully but when i am using power bi imported data with  R script  is showing the above mentioned error even i checked the code but their is nothing wrong with the code i am also attaching the screenshot for your refrences please help if anyone knows it's solution.

 

Error Screenshot (See in the fields section columns are successfully imported, and see the code editor code is also correct, manually created data plots are also showing, only this issue is happening with power bi imported data why ?)

 

  • Well i have solved the problem See the below Screenshot code in R script editor all you have to do is Comment the dataset variable in the editor by default it comes commented but i had uncommented it that's why i saw that error. now see after runnig that code i got output.

     

     

4 Replies

  • Ayush_tiwari08 , As R is case sensitive I has doubt xlab and ylab, which uses sales not Sales. profit, not Profit.

    But this error is even before it. Still change those and check

    • Ayush_tiwari08's avatar
      Ayush_tiwari08
      Helper I

      These are just label titles these parameters doesn't matter and i did changed them but still there is the same error.

    • Ayush_tiwari08's avatar
      Ayush_tiwari08
      Helper I

      Well i have solved the problem See the below Screenshot code in R script editor all you have to do is Comment the dataset variable in the editor by default it comes commented but i had uncommented it that's why i saw that error. now see after runnig that code i got output.