Forum Discussion

NielsDecoene's avatar
NielsDecoene
Icon for Helper I rankHelper I
9 years ago
Solved

DocumentDB Parameters

Hey,   I'm currently having a small problem with a SQL query i'm writing on an Azure DocumentDB in Power BI So i have this simple query: [Query = "SELECT c.id AS Leverancier_ID, c.leverancier_naa...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    NielsDecoene,

    How about changing query to the following?

    DocumentDB.Contents(#####, [Query = "SELECT c.id AS Leverancier_ID, c.leverancier_naam AS Leverancier FROM c WHERE c.type = ""Leverancier"" AND c.project_id = """& Project & """"])

    Regards,

    Lydia

NielsDecoene's avatar
NielsDecoene
Icon for Helper I rankHelper I
9 years ago

Static Query Source overview as follows:

http://prntscr.com/fhpowk

Static Query Advanced Editor:

let
Source = DocumentDB.Contents("https://selectieproject.documents.azure.com:443/", "selectieprojectDB", null, [Query = "SELECT c.id AS Leverancier_ID, c.leverancier_naam AS Leverancier FROM c WHERE c.type = ""Leverancier"" AND c.project_id = ""Project B"""]),
#"Expanded Document" = Table.ExpandRecordColumn(Source, "Document", {"Leverancier_ID", "Leverancier"}, {"Document.Leverancier_ID", "Document.Leverancier"})
in
#"Expanded Document"

 

Hope this helps

Anonymous's avatar
Anonymous
Not applicable
9 years ago

NielsDecoene,

How about changing query to the following?

DocumentDB.Contents(#####, [Query = "SELECT c.id AS Leverancier_ID, c.leverancier_naam AS Leverancier FROM c WHERE c.type = ""Leverancier"" AND c.project_id = """& Project & """"])

Regards,

Lydia

  • NielsDecoene's avatar
    NielsDecoene
    Icon for Helper I rankHelper I
    9 years ago

    Well that worked, putting three " does the trick, who would have thought...

    Any explication about why three are required?

     

    I'll mark this as answered, thanks alot!