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.
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.
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 |
---|---|
15 | |
2 | |
1 | |
1 | |
1 |
User | Count |
---|---|
24 | |
3 | |
2 | |
2 | |
2 |