Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
User | Count |
---|---|
15 | |
2 | |
1 | |
1 | |
1 |
User | Count |
---|---|
18 | |
11 | |
5 | |
4 | |
3 |