Forum Discussion

AdityaG's avatar
AdityaG
Helper I
3 years ago
Solved

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

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...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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.