I have data of 1 year in SQL…I just to fetch data of 1 month in Power BI?

To fetch data of one month from your SQL database in Power BI, you can use Power Query Editor to filter the data based on your desired timeframe. Here’s a step-by-step guide:

  1. Open Power BI and go to the “Home” tab.
  2. Click on “Get Data” and choose the appropriate SQL database connection option (e.g., SQL Server, MySQL, etc.).
  3. Provide the necessary connection details to connect to your SQL database and click “Connect.”
  4. In the “Navigator” window, select the table(s) you want to import and click “Load” or “Transform Data” to open the Power Query Editor.
  5. In Power Query Editor, locate the column that contains the date information you want to filter.
  6. Right-click on the column header and select “Filter” from the context menu.
  7. In the filter options, choose the “Date” or “Month” filter, depending on how your date data is structured.
  8. Specify the range or specific month you want to filter, and click “OK.”
  9. Power Query Editor will apply the filter, and you will see the filtered data in the preview pane.
  10. Click “Close & Apply” to load the filtered data into Power BI.

By following these steps, you should be able to fetch and display data for a specific month from your SQL database in Power BI.

Leave a Comment