Excel Format with automatic table creation...is it possible?

[#1]

When we publish/export report in Excel Format, can we create a table within Excel automatically?

*I want to connect this Excel file to connect to MS PowerBI.

But PowerBI can not read the data if the excel file does not contain a table...

[Former Member · Accepted solution]

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

Connect to SAP BusinessObjects BI Universes with Power Query - Excel

[Former Member · Accepted solution]

Thank you !

[Former Member]

Hello Hayden,

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.

Let me know if this works out for you.

Regards

Niraj

[Former Member]

Hi Niraj

Thank you so much always for your help...you help me a lot!

OK I have Live Office but in order to get the latest instance, do I need to open Excel?

I want to automate the process...

[Former Member]

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.

Regards

Niraj

[Former Member]

Thank you Niraj but Is there any way to do this without opening file?

I must automate this process

[Former Member]

Per my knowledge Web services could be another option in that case

Regards

Niraj

[Former Member]

I wish I could use Web Services in PowerBI.

I do not think it is available at this time.

I found the link below...

SAP – Microsoft Power BI