From the course: Power BI Weekly

Unlock this course with a free trial

Join today to access over 25,600 courses taught by industry experts.

Translytic user data functions

Translytic user data functions - Power BI Tutorial

From the course: Power BI Weekly

Start my 1-month free trial Buy for my team

Translytic user data functions

“

Power BI mostly consumes data. Fabric user data functions let us reverse this flow by writing back values into a SQL database. To set this up, we need to first create a database table where we want our inputted values to go. We'll then create a new user data function with the help of the Python language. Finally, we need to test out our function to make sure that it works. We'll create this function in a workspace specific to Transletic Flows so we can easily parse its components. Let's start by creating a new SQL database by choosing it from the option menu of items available within our Fabric workspace. We'll call this new database Output. Once Fabric creates this database, let's add a table to it by opening up a new query that we'll call createTable. To create a new table, we'll use the createTable clause followed by the names, which is the name of the table that we want to create. We'll then add parentheses to this query where we can specify the names of the columns that we want…

Contents