Such a great demo. Thank you so much! I have never done coding but I am gonna try to do 1 API call from Power BI from your video.... just to check if I can do it. I am so grateful that you are providing this knowledge for free. All your demos are very helpful....
Thanks. In real-world scenarios, data ingestion often involves dealing with authentication mechanisms like OAuth 2.0, pagination, and handling large volumes of data. While Power Query is a powerful tool for data transformation and preparation, it is not be the most suitable choice for complex data ingestion tasks, especially at a large scale for Rest API. Azure Data Factory is a powerful tool for data ingestion, it doesn't necessarily replace Power Query. In fact, you can leverage the strengths of both tools by using them in tandem
Was thinking the same, more complex scenarios was looking at an Azure App Function to run every 'n' minutes and pull in data from external API (with keys, only updated items etc), and write an Azure table. Azure Data Factory presume can do this and take the legwork out of writing your own app function (not that its hard, but it would take time)?
How do you do it when you don't know how many projects/pages you will need and if that number of results is variable?
4 หลายเดือนก่อน
trying to connect to private api but after pitting the details in getdata->web Getting Details: "The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel." error
Your solution on pagination is amazing. Saved me so much time! Thanks
OMG you just solved my problem with pagination! Amazing! Thank you a lot :D
That's what I've been looking for an entire week, thanks ! 🙏
Such a great demo. Thank you so much! I have never done coding but I am gonna try to do 1 API call from Power BI from your video.... just to check if I can do it. I am so grateful that you are providing this knowledge for free. All your demos are very helpful....
Huge help my friend!!! Thank you very much!
Tooooooooooooooo tooooooooooooooooo Goood with content and Explaination
Thank you that is great video with lots of nice demonstrations.
thank you bro it helped me alot
Got me past 3 walls with this one video, thank you.
Thanks.
In real-world scenarios, data ingestion often involves dealing with authentication mechanisms like OAuth 2.0, pagination, and handling large volumes of data. While Power Query is a powerful tool for data transformation and preparation, it is not be the most suitable choice for complex data ingestion tasks, especially at a large scale for Rest API.
Azure Data Factory is a powerful tool for data ingestion, it doesn't necessarily replace Power Query. In fact, you can leverage the strengths of both tools by using them in tandem
Was thinking the same, more complex scenarios was looking at an Azure App Function to run every 'n' minutes and pull in data from external API (with keys, only updated items etc), and write an Azure table. Azure Data Factory presume can do this and take the legwork out of writing your own app function (not that its hard, but it would take time)?
@@themorleyc Yes. Through Data Injection Pipeline Configuration. Alternatively Databricks Notebook can also do this on scale.
Does someone know how to get the data from the repositories? For example excel files when he shows his repos at 14:00 ?
Can you please make a video on how GraphQl connects to PowerBI? I mean bringing data into powerBI report using graphQL endpoint URL
How do you do it when you don't know how many projects/pages you will need and if that number of results is variable?
trying to connect to private api but after pitting the details in getdata->web Getting Details: "The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel." error