Responsive Ad Area

Share This Post

test

Credentials are required to connect to the SQL source

I’m trying to get a token from my SQL server. Everytime I run it in VS2017 I’m prompted for credentials. The SQL connection should be made with integrated authentication but the datasource kind of SQL seems like I have a mismatch between what I can enter in the tester and what my code needs to connect.

Any help would be appreciated.

[[DataSource.Kind="PQExtension1", Publish="PQExtension1.Publish"]
shared PQExtension1.Contents = (optional message as text) =>
    let
        _message = if (message <> null) then message else "(no message)",
        a = "Hello from PQExtension1: " & getToken()
    in
        a;



getToken = () =>
    let
        t = Sql.Database("sqlserver", "accounting", [Query="EXEC GetToken"]),

        token = Table.FirstValue(t)
    in 
        token;



PQExtension1 = [
    Authentication = [
        Implicit = []
    ],
    Label = Extension.LoadString("DataSourceLabel"),
    SupportsEncryption = false
];][1]


Credentials are required to connect to the SQL source
Credentials are required to connect to the SQL source
test
{$excerpt:n}

Share This Post

Leave a Reply

Your email address will not be Publishedd. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

Skip to toolbar