Forum Discussion

justinsocialdec's avatar
justinsocialdec
New Member
9 years ago
Solved

Excel in Onedrive

  Hi   im wanting to auto update my report based on an excel file in onedrive. my issue is i have formatted the table in powerbi desktop yet the im unable to do that same formating in excel or ...
Need Help
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    9 years ago

    Hi justinsocialdec,

     

    In Power BI, we can only modeling data in Power BI desktop, like create calculated columns/measures, change column data category. In service, we are not able to do such features. You need to do data modeling in desktop then save the report, publish it to Power BI service.

     

    In Power BI desktop, we can only export visual data to CSV files.  But in Power BI service, we can export to Excel as well as CSV files. See: Export data from Power BI visualizations. Besides, we can use Analyze in Excel to use Excel to view and interact with a dataset that we have Power BI. In your scenario, I would suggest you publish the report from desktop to service, then use Export Data to Excel or Analyze in Excel features.

     

    Best Regards,
    Qiuyun Yu

     

     

v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
9 years ago

Hi justinsocialdec,

 

In Power BI, we can only modeling data in Power BI desktop, like create calculated columns/measures, change column data category. In service, we are not able to do such features. You need to do data modeling in desktop then save the report, publish it to Power BI service.

 

In Power BI desktop, we can only export visual data to CSV files.  But in Power BI service, we can export to Excel as well as CSV files. See: Export data from Power BI visualizations. Besides, we can use Analyze in Excel to use Excel to view and interact with a dataset that we have Power BI. In your scenario, I would suggest you publish the report from desktop to service, then use Export Data to Excel or Analyze in Excel features.

 

Best Regards,
Qiuyun Yu