Power BI - Getting Data
Which Power Query M function is typically used to retrieve data from a REST API in Power BI?
Which Power Query M function is typically used to retrieve data from a REST API in Power BI?
easy📝 Conceptual Q3 of 15
Step-by-Step Solution
Solution:
Step 1: Identify REST API connection function
Web.Contents is used to call REST API endpoints and retrieve raw data.Step 2: Eliminate other options
OData.Feed is for OData sources, Csv.Document parses CSV files, Excel.Workbook reads Excel files.Final Answer:
Web.Contents -> Option DQuick Check:
Web.Contents fetches web data [OK]
Quick Trick: Use Web.Contents to call REST APIs in Power Query [OK]
Common Mistakes:
- Using OData.Feed for REST APIs
- Confusing CSV or Excel functions with API calls
- Assuming Web.Contents parses JSON automatically
Master "Getting Data" in Power BI
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore Power BI Quizzes