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…
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…
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…
Convert TRUE and FALSE into 1 and 0 in Power BI
Here is a simple way how to convert TRUE and FALSE into 1 and 0 in Power BI. Precisely speaking – Power Query…
How to convert accented characters to unaccented in R or Power BI
Sometimes it’s necessary to convert accented characters to non accented in R or Power BI for text analysis purposes. Accented characters might be…
Dynamic Power BI map visualization with coronavirus data
With the help of additional custom visualization, it is possible to create pretty awesome dynamic Power BI map visualization to see how things…
How to add leading zeros in R, Power Query, DAX or Excel
Here are multiple examples of how to add leading zeros in different ways and places. In these examples, I will add them to…
How to combine Excel sheets with Power Query
Here is a simple and easy way how to combine tables from multiple Excel sheets with Power Query in Excel or Power BI.…
How to create group index with Power Query or R
It is possible to generate a group index (unique row ids) by one or many groups in Power Query. It comes handy when…
How to create a flexible calendar table with Power Query
Here is an example of how to generate calendar based on two input values – date of the first day and date of…