Cells To Filter Fact Table Via Start and End Date

Hi Anonymous , thank you for reaching out to the Microsoft Fabric Community Forum.

1. Once you have the filtered table in Power BI, you can export it to Excel by using the "Export Data" feature.
2. In Excel, you can set up a query that connects to the Power BI dataset. To do this, go to the Data -> Get Data"-> From Power BI.
3. Sign in to your Power BI account if you aren't already.
4. You'll see a list of available datasets. Select the dataset that contains your filtered data.
5. Click "Load" to import the data into Excel. This will create a query that dynamically pulls data from your Power BI dataset.
6. You can set the query to refresh automatically or manually based on your needs. To do this, right-click on the query in the "Queries & Connections" pane and select "Properties."
7. In the query properties, you can set the refresh options, such as refreshing the data when the file is opened or at specific intervals.
8. Any changes in the Reporting Start Date and Reporting End Date will dynamically refresh the data in Excel.
   

    

If this helps, please consider marking it 'Accept as Solution' so others with similar queries may find it more easily. If not, please share the details.
Thank you.