use build-in function from sql database - tabula of priority erp software

[Anonymous]

I imported table from SQL priority software which contain column of date.

The value I get is numeric - how can I convert it to normal date column.

I know there is special function on priority software SQL

The function is: dbo.system.tabula_dateconvert("date value")

I import the system table with this function - how can I use it?

I am new with POwer BI programming.

Thanks,

Liora

[Anonymous]

Hi  @Anonymous ,

You can directly write your queries using Advanced option in SQL source. It allows using All SQL functions.

You can click on data source (sql server) -- Advanced options -- SQL statement

Refer to:

How to create Select query with where clause with ... - Microsoft Power BI Community

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi

We work with ERp program called "PRIORITY SOFTWARE" .

It works with sql.

I imported a table from this database.

one of the table column sopose to be a date - but I see a long integer number insted.

Becuse I femilier with this program - I konw there is function on SQL - that can convert this number to correct Date

How can I import/use the function that store on the sql database

[amitchandak]

@Anonymous ,The information you have provided is not making the problem clear to me. Can you please explain with an example.

refer if this can help

https://www.c-sharpcorner.com/article/execute-sql-server-stored-procedure-with-user-parameter-in-power-bi/

Appreciate your Kudos.

[Anonymous]

I found a solution in the internet that explain how to use custom function.

At the first line - was written:

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.

Can you explain How can I do it..  

I manage to import tables from sql - how can I import also the Function??

Liora