-
Customizing ChatGPT: Answering Questions about Your Own Data with Embeddings

ChatGPT is trained on a large set of data but what if you want it to answer questions about your own data, for example building a chatbot that answers questions about your knowledge base? The answer is embeddings and in this blog post I explain the underlying mechanisms and how to implement them. The code…
-
Incorrect Power BI Report Data After Refresh

You just spent a lot of time designing your report and now it’s time to upload it to the Power BI Service. After setting up the credentials for the data source, you hit refresh to make sure the data can be pulled from the source. The refresh completes without error and you switch over to…
-
Impact of renaming columns in Power BI

Renaming columns in Power BI can have a severe impact on your reports. Initially, renaming columns in Power BI ensures that your end users don’t have to deal with cryptic system names from your source system. Over time, you may need to change a name of a column because of new terminology or to standardize…
-
Connecting Power BI to remote SQL Server from outside the domain with Windows authentication
As an external employee or consultant, you sometimes have to connect to on-premises data from a remote location. We recently ran into troubles while connecting to a MS SQL Server from a machine which was not in the same domain as the SQL Server. The user credentials and the VPN connection was in place but…