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.
Hello world,
I'm triyng to achieve my fourth custom connector as I ran in a strange issue.
While trying to caoncatenate strings I receive this error :
`We cannot convert the value "https://api....." to type Function`
But, using a full string instead of concatenated variables just work.
Is is the relevant part of the code throwing the error:
api_base_uri = "https://api.linkedin.com/v2";
[...]
url = if (next_url <> null )
then next_url
else api_base_uri & "/organizationPageStatistics?" & Uri.BuildQueryString( [
q = "organization",
organization = organization_urn
] )
And the modifed part that just works:
url = if (next_url <> null )
then next_url
else "https://api.linkedin.com/v2" & "/organizationPageStatistics?" & Uri.BuildQueryString( [
q = "organization",
organization = organization_urn
] )
Any thought is welcome
Solved! Go to Solution.
Fixed
I had a source kind definition tag(?) like '[DataSource.Kind="LinkedIn", Publish="LinkedIn.Publish"]' above API variables definition.
HI @5AMsan,
I think this may be related to the M query evaluation, these variable values seem not fully recognized when executing the concatenate operations. You can take a look at the evaluation model of power query if helps:
Evaluation model - PowerQuery M | Microsoft Learn
Regards,
Xiaoxin Sheng
Fixed
I had a source kind definition tag(?) like '[DataSource.Kind="LinkedIn", Publish="LinkedIn.Publish"]' above API variables definition.
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.
User | Count |
---|---|
14 | |
2 | |
2 | |
1 | |
1 |
User | Count |
---|---|
21 | |
2 | |
2 | |
2 | |
2 |