How to Read Data from API - Power BI Tutorial (41/50)

How to Read data from API
How to read API Source data.
How to connect to application that is not listed in Power BI Source

#PowerBI #PowerBIDesktop #PowerBITutorials

Complete Playlists

[nimishbhatia]

Quick and simple video. Once we have renamed columns, deleted columns etc and completed the query, could you please advise how to refresh this API data when changes to the data in the API occur? A manual refresh doesn't seem to re-fetch the data.

[jyothinadiya]

Hi nags, how we get powerbi scheduled refresh failure notifications. Can you pls suggest any link or video related to it. Thanks!

[MrSanthosh]

Hi Brother,
Thanks for the information.
I have a API and after execution will download an excel sheet. I want to automate these steps in power bi, kindly provide inputs on this.
Thanks

[rashane]

Hi Nags, first of thanks for creating this valuable channel. It helps a lot of users and potentially those whose starting their career as power bi dev. Having said that, may I humbly request to have a video on having a datasource of an API with an oauth2 authentication? Much appreciated and may you have more subscribers to come :) Cheers!

[surender]

Hello Sir, Please help me, I want to import data from apache druid database but not found any options to connectivity. Please suggest me.

[anaghahuddar]

I want to fetch values from the power bu visual(cards) how can I achieve that using power bi api?

[tusharshinde]

Thanks for sharing knowledge...
Appreciate your work...
But this Power BI ( /50) playlist is not available in playlist...
162 video playlist is available...

[cnu]

Hi nag, can you please explain how to connect with azure dev ops as well as sprints, capacity

[ahv]

Hi,

I am getting data from an API that has two parameters like below in the URL:



These are the start and end dates of the report that I have manfully set up in the API URL. But, how do I make it dynamic so that everyday that I refresh the data in Power BI connect to the API and pull the latest data? My current M code is something like below:


let
Source = Json.Document(File.Contents("C:\Users\Ali\AppData\Local\Microsoft\Windows\INetCache\IE\EHD7MHFN\1120")),
#"Converted to Table" = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
#"Expanded Column1" = to Table", "Column1", {"txtProvider",
"txtIncidentNo",
"FltDate",
"LogTime")

[swapnab]

Hi, how to change datasource from Azure storage to API ?

[pritichaudhari]

Hello,

Would you please make a video on, how to get Data from RESTful API which has "two Factor Authentication" e.g. Maconomy RESTful API framework.

Thank you.

[lakshmikanthparvathapuram]

Hi Sir,
Thank you so much for your explanation..
Could you also make a video on to differentiate " Duplicate" and "Reference" in Edit queries

[alamkhan]

loading blocked by failures with other queries while refreshing API data