Importing API Data into Power BI - News Catcher
Importing API Data into Power BI - News Catcher #powerbi #api
Power Query is the data connectivity and preparation technology enabling end users to seamlessly import and reshape data from within a wide range of Microsoft products, including Excel, Power BI, Analysis Services, Dataverse, and more.
In this video, we will see how to ingest news data through an API with Power Query transformations to clean the data and do some advanced transformations.
Get the API key from the below websites.
https://newscatcherapi.com
https://developer.nytimes.com/apis
https://newsapi.org/sources
Timelines
0:00 Intro
0:35 Get News Catcher API
1:11 Get data in Power BI
1:47 Power Query Transformations
3:55 Parameterization
4:37 Append Queries
6:21 Disable Query Load
6:43 Set Data Category
7:45 Adding Removed Columns
8:41 Refresh Issues
Visit https://www.datamuallem.com for more tips and tutorials.
👉 Please subscribe to my channel for more videos 💡
💜 Let me know in the comments which topic you would like to see a video on next.
Thanks for being a part of this channel and for all your support! 🔥🔥
#PowerBI #DataMuallem #DataTraining
#powerbidesktop #powerbitraining #powerbideveloper #DAX #dashboarddesign #design #reportdesign #powerbidesign #powerquery #newsapi
