How to connect to the Salesforce data with Power Query, Power BI, Excel
Here is how to connect to the Salesforce data with Power Query in Excel or Power BI. For the Salesforce CRM data exploration,…
Add index column in Power Query
Here is how to add an index column in Power Query in 2 easy steps. Index column in Power Query might be useful…
Correct age calculation in Power Query
It is not so easy to do age calculation in Power Query in a way that works all the time correctly. There are…
One of the easiest ways how to generate random numbers in Power Query
If you know how to generate data in Power Query, it might be very useful to create data sets for reproducible examples. Here…
How to calculate ISO year in Power Query
ISO year in Power Query is necessary if you have multiple years and want to group data using ISO week number. Some of…
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…
