Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
Check it out now!Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
So i have no clue what im doing.
I've only ever connected to an api like this once before.
I would love any help. I think i might be pulling the wrong data? I get this error after running the code below:
let
GetAuth = Web.Contents("https://huntsman.acceleratorkms.com/token",
[
Headers = [#"Accept"="application/json",
#"Content-Type"="application/x-www-form-urlencoded;charset=UTF-8"],
Content = Text.ToBinary("username=******&password=******&grant_type=password")
]),
FormatAuthAsJson = Json.Document(GetAuth),
access_token = FormatAuthAsJson[access_token],
ReportData = Html.Table(Web.Contents("https://company.acceleratorkms.com/content/search"), {}),
#"Converted Data To Table" = Table.FromList(ReportData, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
ColumnNames = List.Union( List.Transform(#"Converted Data To Table"[Column1],
each Record.ToTable(_)[Name])),
#"Expanded Report Data" = Table.ExpandRecordColumn(#"Converted Data To Table", "Column1", ColumnNames)
in
#"Expanded Report Data"
@Anonymous , I think you are already getting data in table format and you trying us that as list
I doubt this step Table.FromList , before this step check if you getting expand icon then use that and expand it and test
debug issue
https://www.youtube.com/watch?v=OE6DPmKqN7s
refer how to handle error in power query
https://www.youtube.com/watch?v=OE6DPmKqN7s
https://www.youtube.com/watch?v=9-Lag0VOiTs
If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Hey! I sadly don't get to debug with try because the table i get is completely empty when i expend it i get this:
Sample data:
Operator name | Assigned | Total number of completions in last 365 days | Completed in last 365 days |
| Acknowledgements expiring soon | Acknowledgements expired | Not acknowledged | |
Name 1 | 491 | 47 | 21 | 250 | 0 | 0 | 241 | |
Name 2 | 294 | 0 | 0 | 112 | 0 | 0 | 182 | |
Name 3 | 353 | 0 | 0 | 108 | 0 | 0 | 245 | |
Name 4 | 233 | 35 | 1 | 100 | 0 | 0 | 132 | |
Name 5 | 233 | 8 | 1 | 60 | 0 | 0 | 172 |