Forum Discussion
Right data structure for Inventory Forecast data
- Use “long format” data: Instead of adding new columns each month, add new rows with a ForecastMonth column.
Store all files in one folder: Use Power BI’s Folder connector to auto-merge them.
Automate with Power Query: Clean one sample file, and apply the same steps to all others.
Optional: Extract month from filename if needed.
No more manual edits—just drop the new file in the folder and refresh Power BI
Community SupportHi CK_92,
Thank you for reaching out to the Microsoft Fabric Community Forum.
To help us troubleshoot without exposing sensitive data, could you try creating a small mock dataset that follows the same column names, data types, and general patterns as your real data, but with all values replaced or randomized? Even 5–10 sample rows are often enough for us to test.
Here is a guide you can use to create and share such data safely:
Get samples for Power BI - Power BI | Microsoft Learn
If creating a mock dataset isn’t possible, another option is to share:
- The structure/schema of your tables (column names + data types only)
- The exact DAX formulas or Power Query steps you’ve tried
- A screenshot of the error messages you’re encountering
With that information, we can try to reproduce the issue in our own test environment and work toward a solution.
Thank you.
Community SupportHi CK_92,
We haven’t received a response with the requested sample data to help troubleshoot your issue effectively.
To proceed further, please share a minimal and clean sample dataset (not a screenshot) along with the expected output. This helps the community understand and resolve your question faster.
Thank you.
- v-kpoloju-msft
Hi CK_92,
Please share sample data relevant to this thread and let us know the expected outcome, as this will help us reproduce the scenario more easily.
Thank you.