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