Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

Reply
Anonymous
Not applicable

Token Comma Expected Error when using POST API zip file in Power Query

Hi,

 

I'm new to using API connectors in power query and am trying to figure out how to connect a CSV within a ZIP file using a POST API. I am getting a Token Comma expected error on my Source line. I suspect this has to do with the fact that I am trying to bring in a ZIP file, but I am not sure how to fix this. 

 

Here is the link to the documentation for the API: usaspending-api/awards.md at master · fedspendingtransparency/usaspending-api · GitHub

 

Here is a screenshot of my code:

PBI API Error.PNG

1 ACCEPTED SOLUTION
IHB_BrianC
Frequent Visitor

You haven't closed the body step with ending quotaton (") and a comma.

View solution in original post

1 REPLY 1
IHB_BrianC
Frequent Visitor

You haven't closed the body step with ending quotaton (") and a comma.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors