Using oData feeds in Excel

[dmuchmore]

I have a client that is using Power BI for Office 365. We had created datasets in Power BI, and then created oData feeds from those datasets to use in Excel. The excel files were then shared with staff thru a SharePoint team site, and the staff could open the files in Excel online and do a data refresh and everything worked fine.

I know there have been changes to Power BI since we did this, and the refresh no longer works. I have been unable to figure out how to get this working again. Can any one shed some light on this?

[v-qiuyu-msft · Accepted solution]

Hi @dmuchmore,

If I understand you correctly, you connect to Power BI dataset in Excel before, then share the Excel with others. Then other users can refresh the Excel to see updated data, right?

In your scenario, as the Power BI for Office 365 is retired, you can use the current version of Power BI. In Power BI, there is Analyze in Excel feature for us to view and interact with a dataset that we have Power BI in Excel, then share this Power BI dataset connected workbook with others, and users can refresh data in Excel desktop version when they open the workbook. For more information, see: Analyze in Excel.

Best Regards,
Qiuyun Yu

[dmuchmore]

Qiuyun,

Thank you for your reply. I had thought that might be the case. One other question. Do you know if it is possible to use analyze in Excel with Excel online? I have been finding conflicting information on this.