Forum Discussion

joaoguedes's avatar
joaoguedes
Regular Visitor
8 years ago

Using Import data from SAP BW with Power BI is too slow

Path:

Database -> SAP Business Warehouse Application Server -> Connect

 

When I use "Import" from SAP BW Application Server and choose all the characteristics and key figures that are shown in my InfoArea/Cube/Query and press "Load", it's takes forever to run and never finishes.

 

What I am doing wrong ?

Import is not for this proposal ?

Need Help

9 Replies

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    8 years ago

    Hi joaoguedes,

     

    There is nothing special in the process. The cause could be in other parts.
    1. Please upgrade to the latest version of Power BI Desktop.

    2. What's the size of the whole data source?

     

    Best Regards,

    Dale

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    It may be because the BEX query itself takes long time to execute  or it is executing/fetching huge set of data. Please test your query using AFO and if require apply some more filters on the query for firster execution.

    • joaoguedes's avatar
      joaoguedes
      Regular Visitor
      8 years ago

      Hi Anonymous, what is AFO ?

       

      Is there a limit of the data that Power BI can pull from SAP BW ?

       

      My BEx Query has a lot of records, but should that works fine on Power BI ?

      or 

      Is there a limit of the data that Power BI can pull from SAP BW ?

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        Hi,

         

        AFO is SAP Analysis for Office tool. You can test your query at AFO or RSRT. 

        Maximum size it allows is 1 GB.

         

        But we must understand that Power BI is not ment for a tabular reporting solution which will display 1 GB of data. You must add some filter/variable and bring aggregated data into Power BI and display using the visualizations.

  • Janel's avatar
    Janel
    Frequent Visitor
    8 years ago

    Hello,

    I need to solve this one, too.  I am only able to pull in very limited data, as in, not enough to do any reporting on.  Anytime I try to pull more it errors out.  

    Janel

  • joehigab's avatar
    joehigab
    Regular Visitor
    7 years ago

    Same problem here. this is quite a big limitation for me in PBI. I hope they can fix it soon.

     

    at least there is no need to load each dimension when you click on it, maybe choose all dimensions then apply to update once for all....