This question is for Microsoft's Power Query product, which I know is different than Live Office, but I figured it was worth asking here in case someone can help.

I am testing out Power Query for the first time. I'm using it to connect to a UNX universe. It seems to be very slow. I ran a test on a very simple query with a single column (varchar200), from a table with only 41000 records. When I refresh that query, it runs for 34 seconds, and it shows almost 20 MB in the status while it is updating. I tried the "Fast Data Load" option, and it runs for 41 seconds. This makes no sense why it would be so slow.

If I run the equivalent SQL query directly against the database in Power Query, it only takes one second. And if I create a similar report in Crystal Reports, it takes about 17 seconds (still slow, but not as bad). Why should my test be so slow? Is there a configuration option on the BO server that I need to look at, or is Power Query inherently slow with BO Universes?

I know this is a late response - but i am posting this to warn against using PowerQuery for SAP BusObj based universes. PowerBI already has removed the connector to BusinessObjects and I got the info this week that PowerQuery would also remove this connector in a subsequent update/release. Apparently there's a licensing conflict around these products and the roadmap isnt clear for Bobj connectivity support ._________________Shobhit Acharya
๏̯͡๏﴿

I know this is a late response - but i am posting this to warn against using PowerQuery for SAP BusObj based universes. PowerBI already has removed the connector to BusinessObjects and I got the info this week that PowerQuery would also remove this connector in a subsequent update/release. Apparently there's a licensing conflict around these products and the roadmap isnt clear for Bobj connectivity support .

Can you provide more detail, and give me your source for this information? This is a big decision for our team, and if we abandon PowerQuery, I want to be confident this is a real concern. Also, can you recommend alternative methods to access universe data without using WebI or Crystal Reports?

I know this is a late response - but i am posting this to warn against using PowerQuery for SAP BusObj based universes. PowerBI already has removed the connector to BusinessObjects and I got the info this week that PowerQuery would also remove this connector in a subsequent update/release. Apparently there's a licensing conflict around these products and the roadmap isnt clear for Bobj connectivity support .

Can you provide more detail, and give me your source for this information? This is a big decision for our team, and if we abandon PowerQuery, I want to be confident this is a real concern. Also, can you recommend alternative methods to access universe data without using WebI or Crystal Reports?