Migrating data from Power BI to particular Excel sheet to transform the data

[AdityaG]

Hi all,

Not sure if I'm asking on the right forum, but I had a query.

I want to get Excel data into Power BI and then send it to another Excel, which then gets processed in the Excel itself. The processed data is then fed into the same Power BI (or different if not possible).

Eg: Input data Excel -> Power BI -> Processed data Excel -> Power BI

If Input data changes annually, the user can simply load the updated Input data. The user then refreshes the Power BI and in this process, the Input data gets exported to another Excel (Processed data Excel), where through formulas and stuff, the Input data gets processed into a more refined table. This table then gets pulled into the Power BI, where the rest of the transformation takes place.

The idea behind this is that the user doesn't have to open Excel and can only directly communicate with Power BI only.

Let me know if it's possible.

[v-rzhou-msft · Accepted solution]

Hi @AdityaG ,

1. Input data Excel -> Power BI

Power BI support us to get data from excel directly.

2. Power BI -> Processed data Excel 

As far as I know, currently we can export data from visual to excel/analysis in excel on Power BI Service or connect to live Power BI dataset in excel. All of them are not good choice to prepare for the new data source.

Here I suggest you to try to create a dataflow by this dataset on Power BI Service. 

Then use this dataflow as data source in Power BI.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.