Forum Discussion
Rest API get call in power bi with headers and token
Thank you for using Microsoft Community Forum. thanks rohit1991 bhanu_gautam for your inputs. in addition am adding below points.
You don’t need to include all headers—only those required for the API call to succeed. Typically, this includes the Authorization header (e.g., Bearer YOUR_ACCESS_TOKEN), Content-Type (usually application/json), and any custom headers specified by the API documentation. In Power Query, headers are added in the Advanced Editor using M code, where you define them within a Headers record passed to the Web.Contents function. Power Query doesn't offer a separate UI for adding multiple headers, so you'll need to input them directly in the script. If you’re unsure which headers are necessary, start with the essentials and add others only if the API response indicates missing or invalid headers.
If this information is helpful, please “Accept as solution” and give a "kudos" to assist other community members in resolving similar issues more efficiently.
Thank you.
Thank you for using Microsoft Community Forum. thanks rohit1991 bhanu_gautam for your inputs. in addition am adding below points.
You don’t need to include all headers—only those required for the API call to succeed. Typically, this includes the Authorization header (e.g., Bearer YOUR_ACCESS_TOKEN), Content-Type (usually application/json), and any custom headers specified by the API documentation. In Power Query, headers are added in the Advanced Editor using M code, where you define them within a Headers record passed to the Web.Contents function. Power Query doesn't offer a separate UI for adding multiple headers, so you'll need to input them directly in the script. If you’re unsure which headers are necessary, start with the essentials and add others only if the API response indicates missing or invalid headers.
If this information is helpful, please “Accept as solution” and give a "kudos" to assist other community members in resolving similar issues more efficiently.
Thank you.
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.