Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Data Extraction from SAP BW Bex Queries to Power BI

Dear community, 

 

I am reaching out to Power BI Users who have experience in using SAP BW as source to advice on the behaviour of the Power Query.

 

(1) In our Query designer, for the InfoObject Month, it has been set to extract data according to
  availability of master data 

(2) When we drill down using other InfoObjects, I  suppose to see data according to the master data Month range, eventhough there is no value  for the particular month( denotes as zero) 

 

(3) When I extract the data into Power BI, at the Power Query, the rows that have zero values for the three columns (started,finished,Cancelled) is not being loaded into the Power Query.

(4) Thus, when I plot the graph at the power BI, the empty months are not being displayed
      when I suppose to have 12 data points 

 

 

Does anyone have encountered this situation before and kindly advice on how I can troubleshoot further ? 

Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Community,

     

    I have implemented the workaround in the Power BI such as

     

       (1) Created a custom calendar table and estabished relationship with the source table and 

       (2) Created separate measures based on the physical columns which will return 0 for the 
             blank columns

       (3) Now, I am able to plot the line graph for the continuous interval months

     

     

     

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Community,

     

    I have implemented the workaround in the Power BI such as

     

       (1) Created a custom calendar table and estabished relationship with the source table and 

       (2) Created separate measures based on the physical columns which will return 0 for the 
             blank columns

       (3) Now, I am able to plot the line graph for the continuous interval months