BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Follow BOB on Twitter! 
Follow BOB on Twitter! (Opens a new window)  

General Notice: No events within the next 45 days.

Power Query slow for a simple query via a Universe


 
Search this topic... | Search Live Office... | Search Box
Register or Login to Post    Forum Index -> Other Products -> Live Office  Previous TopicPrint TopicNext Topic
Author Message
Tim86
Forum Member
Forum Member



Joined: 12 Feb 2013

Posts: 8



PostPosted: Thu Sep 03, 2015 3:19 pm 
Post subject: Power Query slow for a simple query via a Universe

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?
Back to top
Shobhit_Acharya
Principal Member
Principal Member



Joined: 11 Aug 2005
ASUG Icon
Posts: 490
Location: Michigan



PostPosted: Thu Oct 15, 2015 12:07 pm 
Post subject: Re: Power Query slow for a simple query via a Universe

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
๏̯͡๏﴿
Back to top
Tim86
Forum Member
Forum Member



Joined: 12 Feb 2013

Posts: 8



PostPosted: Fri Oct 23, 2015 9:34 am 
Post subject: Re: Power Query slow for a simple query via a Universe

Shobhit_Acharya wrote:
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?
Back to top
Shobhit_Acharya
Principal Member
Principal Member



Joined: 11 Aug 2005
ASUG Icon
Posts: 490
Location: Michigan



PostPosted: Fri Oct 23, 2015 9:50 am 
Post subject: Re: Power Query slow for a simple query via a Universe

My sources are direct from Microsoft product and sales team. I have names, but dont want to reveal them in this forum. I work for a fortune 100 company- so rest assured, they would have the right people to respond back to us. If you can reach them through the sales channels, I'd advise reaching out to be 100% sure .
Also - some buzz around this in the PowerBI forum and the "Idea" forum: http://community.powerbi.com/t5/Integrations-with-Files-and/SAP-Universe-connector-for-new-PowerBI-Desktop-app/m-p/1399#M396

Alternatives would be live office in the BI Suite that provides the similar features as the PowerQuery>Unx connector.

_________________
Shobhit Acharya
๏̯͡๏﴿
Back to top
ABILtd
Forum Enthusiast
Forum Enthusiast



Joined: 08 Feb 2006
ASUG Icon
Posts: 1819


flag
PostPosted: Fri Oct 23, 2015 11:02 am 
Post subject: Re: Power Query slow for a simple query via a Universe

Tim86 wrote:
Shobhit_Acharya wrote:
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?


For what it`s worth, I also thought it was slow when I tried it.

Only thing I could think of as an alternative is to expose either queries, or report parts as web services and then consume the web services with something else. QAAWS never seemed to massively scale well though, it`s not like it`s got a heavy hitting SOA behind it. Worth a shot. Not easy to consume SAP BI metalayers with anything, they`re so flippin proprietary.

_________________
BI and Analytics Presales Consultant
------------------------------------------------------
BOXI R1, R2, R3, R3.1, R4.1, R4.2, CE 8, 8.5, 9, 10, SAP Analytics Cloud, Crystal Reports, Lumira, PowerBI, Tableau, JasperServer, iReport, LogiAnalytics, BIRST, Qlikview, Xcelcius, Netezza, T-SQL, PLSQL, DTS, SSIS, BODI, BODS, Kimble etc....
------------------------------------------------------
Back to top
vvp1985
Forum Member
Forum Member



Joined: 01 Oct 2016

Posts: 1



PostPosted: Fri Mar 23, 2018 6:21 am 
Post subject: Re: Power Query slow for a simple query via a Universe

What is difference between Power Query and Live office.

Please suggest
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Other Products -> Live Office  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0336 seconds using 17 queries. (SQL 0.0040 Parse 0.0010 Other 0.0287)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo