Category: Power Query
How to get LiveChat API data with Microsoft Excel or Power BI
Here is an example with getting LiveChat transcripts right into Microsoft Excel Power Query or Power BI. Chat conversations are not the most convenient data what you can get through the API, because results are divided into pages, each containing 25 chats. So in the further post is a simple method of how to make…
How to generate date and time interval list using Power Query
One thing I love about Microsft Power Query is the ability to make lists. It means that you can generate data without some additional source. I will show you how to make list with the last seven days and 15 minute time intervals. It is useful when you combine it with data, where several periods…