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.
in
How to restore deleted MS Teams channel
If you are here, then I suppose that it is not so intuitive to restore the deleted MS Teams channel.
in
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.
in
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 […]
in
How to use OpenWeather API in R
Here is an approach that doesn’t require a dedicated package for using OpenWeather API in R.
in
How to create an empty data frame in R
Here is how to make an empty data frame in R only with column names. Choose between 4 different methods that you can use to achieve that, and decide which of those fits better for you.
Left join only selected columns in R
If you want to use dplyr left join or any other type of join in R to combine information from two or multiple data frames, this post might be very helpful. Here is how to left join only selected columns in R.
in
Press Win + V to access clipboard history
Windows shortcut Win + V is very helpful when you need to access something from your clipboard history. For example, if you work with some Excel files or data sets and have to apply some of the previous filtering parameters.
in