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 ...
Need Help
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.

    • joaoguedes's avatar
      joaoguedes
      Regular Visitor
      8 years ago

      And how can I know how much is the size of my data ?

       

      Even if I use filter in my query at me time I choose the key figures and characteristics, Power BI can't display the data.