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
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)?
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....
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
Tooooooooooooooo tooooooooooooooooo Goood with content and Explaination
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.
Got me past 3 walls with this one video, thank you.
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!
Does someone know how to get the data from the repositories? For example excel files when he shows his repos at 14:00 ?
Thank you that is great video with lots of nice demonstrations.
That's what I've been looking for an entire week, thanks ! 🙏
thank you bro it helped me alot