Forum Discussion

JoshSHardscape's avatar
JoshSHardscape
Helper I
8 years ago

CRM Import

Hi all,   I'm currently trying to import data from our online CRM software, Workbooks. I have created a csv download link for a "report" with all the data I require and combined it with my api key ...
v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

Hi JoshSHardscape,

 

Did you change the blue part by hand? Its default value is "true".

#"Use First Row as Headers" = Table.PromoteHeaders(Source, [PromoteAllScalars=false]),

If it's "false", I can reproduce the same error message.

Please change it to "true" and try it again.

CRM_Import

 

Best Regards,

Dale

 

 

  • JoshSHardscape's avatar
    JoshSHardscape
    Helper I
    8 years ago

    Hi Dale,

     

    Thanks for your reply, 

     

    The query I posted is an exact copy of what Power BI automatically generated once I chose the source, I didn't edit this in any way but I will look out for this being set to false in future and change it! On a side note I managed a temporary solution of simply removing the first fow instead of promoting it and then manually renaming columns. I'll change the Promoteallscalars variable next time I use the data and mark the answer as a solution if it works out!

     

    Ta,

     

    Josh