Call an Azure Function from Power BI


  1. Maybe I am not understanding this correctly but this function call will be fired for every single record to determine the hour offset based on whether the date is in/outside of daylight savings ?
    Seems like a huge overhead particular if you are dealing with thousands of records, which means thousands of server calls??

    1. Author

      You are correct that it would not be a good solution to call a function for every row. This post was meant to demonstrate the possibility of calling an Azure Function from Power BI, and to highlight the deficiency related to Daylight Savings Time in Power BI time functions.

      Less frequent function calls could be a viable solution. For example, calling a function to get an accurate timestamp during a dataset refresh.

Leave a Reply (Markdown formatting available)

This site uses Akismet to reduce spam. Learn how your comment data is processed.