SQL Functions in Power BI

[MV23]

I have a sql function defined in my Azure SQL Server database.

Does anyone know how I can call that function in Power BI?

I am able to see that function in the Data Sources tab and did select it. I want to use that function to create a new column in the tabular representation of the data in Power BI.

[v-jiascu-msft]

Hi @MV23,

Could you please mark the proper answer as solution or share the solution if it's convenient for you? That will be a big help to the others.

Best Regards!
Dale

[MV23 · Accepted solution]

Thanks. I was able to get to it this way.

1. Select the sql function when you initially select your data sources. If you forget to do that, click on "Get Data" or "Recent Sources" and select the function you'd like to add.

2. Then, click on "Edit Queries".

3. Select the table that you want to add the new column to.

4. Click on "Add column".

5.  Click "Invoke Custom Function".

6.  Give your new column a name.

7. Select the function you wanted to call.

8. Add a parameter if you'd like. You can either add a value or select an existing column.

9. Hit "Ok" and you will have your new column.

[v-jiascu-msft]

Hi @MV23,

Thank you for sharing with the community!

Best Regards!

Dale

[Anonymous]

Yes you can!  I've done this recently with an SQL database.  When you say "Get Data" and select your Server/Database, there is an Advanced Options.  There will be an SQL statement box.