Power BI - Getting Data
Which Power Query M function is used to connect to a REST API endpoint in Power BI?
Which Power Query M function is used to connect to a REST API endpoint in Power BI?
easy📝 Formula Fix Q12 of 15
Step-by-Step Solution
Solution:
Step 1: Identify function for REST API calls
TheWeb.Contents()function fetches data from any web URL, including REST APIs.Step 2: Differentiate from OData function
OData.Feed()is specific for OData sources, not generic REST APIs.Final Answer:
Web.Contents() -> Option BQuick Check:
REST API = Web.Contents() [OK]
Quick Trick: Use Web.Contents() for REST API URLs [OK]
Common Mistakes:
- Using OData.Feed() for REST APIs
- Confusing CSV import with API calls
- Trying Excel.Workbook() for web data
Master "Getting Data" in Power BI
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore Power BI Quizzes