Articles
Every article Ever Garden has grown, newest first. Narrow them down by topic, tag or a search.
Power Query | How to Load Dynamic SQL Results (Power BI)
I'll explain how to dynamically execute SQL by linking SQL query conditions (e.g., within the WHERE clause) with Power Query parameters.
#power-query#power-bi#sqlPower Query | Creating a Calendar for a Specified Period Using Parameter Configuration (Power BI)
When using Power BI, there are instances where you might want to create a calendar based on dates. In this scenario, I'll explain how to automatically generate a calendar for a specified period, which can be quite useful.
#power-query#power-bi