Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Importing Salesforce .xlsx into Power BI

Hi there,

 

if I import an .xlsx file from Salesforce into Power BI, there are instances where there are merged rows (number may vary) for a particular record.

 

 Essentially there are merged rows that appear as one row and when one tries to import this data, the field will show it as 'Blank' when in fact it is non-empty.

 

I would post an attachement but I'm not sure about the policy here nor is it available.

 

How would I write the DAX query for this? Is this the best route?

 

Thanks for your help.

Need Help

6 Replies

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    7 years ago

    Anonymous not fully sure what you mean by salesforce .xlsx file. are you saying you have two data sources, salesforce and excel file which you want to merge in powerBI?

     

    Please clarify.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    7 years ago

    Hi,

     

    In the Query Editor, there is a Fill > Down feature.  Try that.

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      This worked.

       

      However for existing entries that had '-' it had populated the ones under it from 'null' to '-'.