Data Extraction from SAP BW Bex Queries to Power BI

[Anonymous]

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 ? 

[v-frfei-msft · Accepted solution]

Hi @Anonymous ,

I suggest you to create a support ticket for help.

https://powerbi.microsoft.com/en-us/support/

[Anonymous · Accepted solution]

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

[v-frfei-msft · Accepted solution]

Hi @Anonymous ,

I suggest you to create a support ticket for help.

https://powerbi.microsoft.com/en-us/support/