Forum Discussion
RakeshSinghr
Resolver I
Resolver IExcel connecting to PBI Dataset Refresh Error
I get an error after performing these steps: 1) Created PBI Dataflow entities in Power BI Service 2) In Power BI Desktop, connected live to PBI Dataflow 3) Created star schema and published to ...
- Hi there
Currently Excel workbooks cannot be interacted with in the Power BI Service.
2) Unfortunately as it stands today there is no way to automatically refresh the Excel workbook in the Power BI Service. You could maybe use PowerOn to do this for you?
3) With the new workspace versions you have to use the ODC connection from the report (clicking Analyze in Excel in the Power BI Service) to connect to the data.
GilbertQ
Super User
Super UserHi there
Currently Excel workbooks cannot be interacted with in the Power BI Service.
2) Unfortunately as it stands today there is no way to automatically refresh the Excel workbook in the Power BI Service. You could maybe use PowerOn to do this for you?
3) With the new workspace versions you have to use the ODC connection from the report (clicking Analyze in Excel in the Power BI Service) to connect to the data.
Currently Excel workbooks cannot be interacted with in the Power BI Service.
2) Unfortunately as it stands today there is no way to automatically refresh the Excel workbook in the Power BI Service. You could maybe use PowerOn to do this for you?
3) With the new workspace versions you have to use the ODC connection from the report (clicking Analyze in Excel in the Power BI Service) to connect to the data.