Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi
I have a query below which calls on a parameterp_StartDate. the parameter has a Date type and format d/mm/yyyy.
I get this error
Expression.Error: The import culture matches no exports. Did you miss a module reference?
The Query code is below.
How can I find where the error is?
= let
Source = GetConsolidatedSQLData("Select accountcode, branchcode, departmentcode, transactiondate, transactionamount, periodno, yearno, periodid from GLTRAN Where GLTRAN.TransactionDate >= '"& Date.ToText(p_StartDate, "d/mm/yy", culture ="en-gb") & "'"),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"AccountCode", type text}, {"BranchCode", type text}, {"DepartmentCode", type text}, {"PeriodNo", type text}, {"YearNo", type text}, {"PeriodID", type text}, {"CompanyCode", type text}, {"TransactionAmount", Currency.Type}, {"TransactionDate", type date}})
in
#"Changed Type"
Hi @abaken ,
GetConsolidatedSQLData() is not a built-in function. Is it a custom function? Please check if this custom function is present in the query. The reason for the error seems to be that this custom function cannot be found in the whole query.
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.