Forum Discussion
Using 'Forecasting' analytics in Desktop, how can I get the forecasted data in tabular form?
Have you tried exporting the data from the graph with the forecasts? That is what I have done before to access the forecasted data and brought it back into my Power BI file.
Did I understand what you are trying to do correctly?
Have you tried exporting the data from the graph with the forecasts? That is what I have done before to access the forecasted data and brought it back into my Power BI file.
Did I understand what you are trying to do correctly?
The solution works. I was able to export the data to a CSV and load it back into PowerBI. However, I was hoping there was an automated way to access the forecasted data to avoid export and re-loading.
It would be preferable that the forecast data become part of the data model that I could access. For example, I'd like to create a dashboard that shows the forecast sales line graph the rest of the year and also access key forecasted data for specific calendar dates like year-end and show in a 'card' on the same report. That way, I can see the key forecasted data without hovering over the graphic.
I agree. It would be nice if we were able to automatically access the forecasted data.
