Forum Discussion
use build-in function from sql database - tabula of priority erp software
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
4 Replies
- amitchandak
Super User
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
Appreciate your Kudos.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
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
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.
