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