Hi all,
Data is in Json format :
[
{
"SO_Number": "SO/SW-AHB/002690",
"PO_Date": "03/12/2018",
"Department": "Pepsico - RFPL",
"Class": "RFPL : Pepsico - RFPL",
"Location": "RFPL : Ahmedabad - DC"
}
]
I want this data in power BI to desing PI Chart using NLauth,
query :
let
Source = Json.Document(Web.Contents("https://xyz-sb1.restlets.api.netsuite.com/app/site/hosting/restlet.nl?script=7&deploy=1", [Headers=[Authorization="NLAuth nlauth_account= , nlauth_email= , nlauth_signature= , nlauth_role = ", Accept="application/json"]])),
#"Converted to Table" = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
#"Expanded Value" = Table.ExpandRecordColumn(#"Converted to Table", "Value", {"SO_Number", "PO_Date", "Department", "Class", "Location"}, {"SO_Number", "PO_Date", "Department", "Class", "Location"})
in
#"Expanded Value"
I m getting this error :
DataSource Error : Web.Contents failed to get Contents from url (400) Bad request
Please give me solution, that i can take this json data in power bi table to design PI chart report.
