Question Re: Excel Format with automatic table creation...is it possible? in Technology Q&A https://community.sap.com/t5/technology-q-a/excel-format-with-automatic-table-creation-is-it-possible/qaa-p/11902111#M4469749 <HTML><HEAD></HEAD><BODY><P>Thank you Niraj but Is there any way to do this without opening file?</P><P>I must automate this process</P></BODY></HTML> Thu, 22 Sep 2016 05:33:50 GMT Former Member 2016-09-22T05:33:50Z Excel Format with automatic table creation...is it possible? https://community.sap.com/t5/technology-q-a/excel-format-with-automatic-table-creation-is-it-possible/qaq-p/11902107 <HTML><HEAD></HEAD><BODY><P>When we publish/export report in Excel Format, can we create a table within Excel automatically?</P><P></P><P>*I want to connect this Excel file to connect to MS PowerBI.</P><P>But PowerBI can not read the data if the excel file does not contain a table...</P><P><IMG class="migrated-image" src="https://community.sap.com/legacyfs/online/storage/attachments/storage/7/jiveimages/1040843" width="450" /></P></BODY></HTML> Thu, 22 Sep 2016 05:02:43 GMT https://community.sap.com/t5/technology-q-a/excel-format-with-automatic-table-creation-is-it-possible/qaq-p/11902107 Former Member 2016-09-22T05:02:43Z Re: Excel Format with automatic table creation...is it possible? https://community.sap.com/t5/technology-q-a/excel-format-with-automatic-table-creation-is-it-possible/qaa-p/11902108#M4469746 <HTML><HEAD></HEAD><BODY><P>Hello Hayden,</P><P></P><P>Is it possible for you make use of Live Office. If you have that you can connect that Excel to your BO and get data without exporting and connect that Excel using MS Power BI.</P><P></P><P>Let me know if this works out for you.</P><P></P><P>Regards</P><P>Niraj</P></BODY></HTML> Thu, 22 Sep 2016 05:12:33 GMT https://community.sap.com/t5/technology-q-a/excel-format-with-automatic-table-creation-is-it-possible/qaa-p/11902108#M4469746 Former Member 2016-09-22T05:12:33Z Re: Excel Format with automatic table creation...is it possible? https://community.sap.com/t5/technology-q-a/excel-format-with-automatic-table-creation-is-it-possible/qaa-p/11902109#M4469747 <HTML><HEAD></HEAD><BODY><P>Hi Niraj</P><P>Thank you so much always for your help...you help me a lot!</P><P>OK I have Live Office but in order to get the latest instance, do I need to open Excel?</P><P>I want to automate the process...</P></BODY></HTML> Thu, 22 Sep 2016 05:17:40 GMT https://community.sap.com/t5/technology-q-a/excel-format-with-automatic-table-creation-is-it-possible/qaa-p/11902109#M4469747 Former Member 2016-09-22T05:17:40Z Re: Excel Format with automatic table creation...is it possible? https://community.sap.com/t5/technology-q-a/excel-format-with-automatic-table-creation-is-it-possible/qaa-p/11902110#M4469748 <HTML><HEAD></HEAD><BODY><P>Yes you would need to open Excel if you have Live Office Installed then you will see a Menu Option as Live Office. Select that menu option and you can see different options through which you can connect to Business Objects.</P><P></P><P>Regards</P><P>Niraj</P></BODY></HTML> Thu, 22 Sep 2016 05:31:28 GMT https://community.sap.com/t5/technology-q-a/excel-format-with-automatic-table-creation-is-it-possible/qaa-p/11902110#M4469748 Former Member 2016-09-22T05:31:28Z Re: Excel Format with automatic table creation...is it possible? https://community.sap.com/t5/technology-q-a/excel-format-with-automatic-table-creation-is-it-possible/qaa-p/11902111#M4469749 <HTML><HEAD></HEAD><BODY><P>Thank you Niraj but Is there any way to do this without opening file?</P><P>I must automate this process</P></BODY></HTML> Thu, 22 Sep 2016 05:33:50 GMT https://community.sap.com/t5/technology-q-a/excel-format-with-automatic-table-creation-is-it-possible/qaa-p/11902111#M4469749 Former Member 2016-09-22T05:33:50Z Re: Excel Format with automatic table creation...is it possible? https://community.sap.com/t5/technology-q-a/excel-format-with-automatic-table-creation-is-it-possible/qaa-p/11902112#M4469750 <HTML><HEAD></HEAD><BODY><P>Per my knowledge Web services could be another option in that case</P><P></P><P>Regards</P><P>Niraj</P></BODY></HTML> Thu, 22 Sep 2016 05:36:14 GMT https://community.sap.com/t5/technology-q-a/excel-format-with-automatic-table-creation-is-it-possible/qaa-p/11902112#M4469750 Former Member 2016-09-22T05:36:14Z Re: Excel Format with automatic table creation...is it possible? https://community.sap.com/t5/technology-q-a/excel-format-with-automatic-table-creation-is-it-possible/qaa-p/11902113#M4469751 <HTML><HEAD></HEAD><BODY><P>I wish I could use Web Services in PowerBI.</P><P>I do not think it is available at this time.</P><P></P><P>I found the link below...</P><P><A href="https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/6700286-sap" title="https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/6700286-sap">SAP – Microsoft Power BI</A></P></BODY></HTML> Thu, 22 Sep 2016 05:46:14 GMT https://community.sap.com/t5/technology-q-a/excel-format-with-automatic-table-creation-is-it-possible/qaa-p/11902113#M4469751 Former Member 2016-09-22T05:46:14Z Re: Excel Format with automatic table creation...is it possible? https://community.sap.com/t5/technology-q-a/excel-format-with-automatic-table-creation-is-it-possible/qaa-p/11902114#M4469752 <HTML><HEAD></HEAD><BODY><P>Even I was looking for a solution on a similar lines the other day. I found the below link which might be useful if you are trying to make use of SAP Business Objects Universe in Power BI. Have a look</P><P></P><P><A href="https://support.office.com/en-us/article/Connect-to-SAP-BusinessObjects-BI-Universes-with-Power-Query-3c02c1fb-8613-4aae-9b3d-b65f52dace72" title="https://support.office.com/en-us/article/Connect-to-SAP-BusinessObjects-BI-Universes-with-Power-Query-3c02c1fb-8613-4aae-9b3d-b65f52dace72">Connect to SAP BusinessObjects BI Universes with Power Query - Excel</A></P></BODY></HTML> Thu, 22 Sep 2016 08:20:35 GMT https://community.sap.com/t5/technology-q-a/excel-format-with-automatic-table-creation-is-it-possible/qaa-p/11902114#M4469752 Former Member 2016-09-22T08:20:35Z Re: Excel Format with automatic table creation...is it possible? https://community.sap.com/t5/technology-q-a/excel-format-with-automatic-table-creation-is-it-possible/qaa-p/11902115#M4469753 <HTML><HEAD></HEAD><BODY><P>Thank you !</P></BODY></HTML> Tue, 27 Sep 2016 11:08:51 GMT https://community.sap.com/t5/technology-q-a/excel-format-with-automatic-table-creation-is-it-possible/qaa-p/11902115#M4469753 Former Member 2016-09-27T11:08:51Z