Data Cornering

How to automatically upload files to SharePoint

Here is an example of how to automatically upload files to SharePoint Online by using PowerShell. By knowing how to run PowerShell script from the Windows command line (CMD) you can also build a workaround to upload files during R or Python script execution.

How to sync MS Teams files with local OneDrive folder

If you’re interested to use your MS Teams files like you usually would in File Explorer, then here is how to sync with the local OneDrive folder.

Power Query error: We found extra characters at the end of JSON input

I was getting this error about extra characters at the end of JSON input while trying to connect to my JSON file in SharePoint with Power Query. Try to connect by using SharePoint Folder.

Power Query error: ResourceAccessForbiddenException

Here is one of the explanations if you have this Power Query error ResourceAccessForbiddenException while refreshing your data. If previously everything worked just fine, then the reason might be obsolete (old) authorization.

How to connect to SharePoint file with Power Query or Power BI

There is a couple of ways how to connect to the SharePoint file with Power Query, but first of all, I recommend the connection through SharePoint Folder. It is more versatile and can be used successfully with different file formats – CSV, TXT, Excel, or JSON.

Get full path to current R script

Are you wondering where is my current R script file located and how to determine the full path? Here is how to do that in RStudio or while running in batch mode.

Execute Windows CMD command (PowerShell) from R script

Here is an example of how to execute the Windows CMD command or PowerShell from R script. You can run cmd.exe by using the system function, and input might be something that you can run in CMD.

R time shift problem after merging data

After merging two data frames by the date column, something weird was happening. The records did not match, and one of the date columns appeared with an additional timestamp. In the beginning, I was thinking that something is wrong with the join function from dplyr function that I was using. But as always, there was… Continue reading R time shift problem after merging data

How to use OpenWeather API in R

Here is an approach that doesn’t require a dedicated package for using OpenWeather API in R.