little addition to this nice piece of code

[cheludo]

Thank you so much! Works smoothly!

there is a comma too much before the IN

And just a hint you can use anonymous Login to access the files! Can you explain more on how we can add more data to the import? It´s not possible to see the tables and just choose the table such as contacts deals etc. within PBI right?

[davser]

Hi

I'm really happy that this little code help you. I fixed the comma.

Sorry for the late response.

To Add more data you just need to go to https://developers.pipedrive.com/docs/api/v1 and replace "https://mypipedrive.pipedrive.com/v1/deals" by "https://mypipedrive.pipedrive.com/v1/leads" - if you want the leads for example

Then in PowerBI you just inner join all of them, a bunch of this little scripts.

[cheludo]

Hi David, thanks a lot for your comment. I actually already did this step opening the person database but after that I can´t progress when opening it I can´t find the data or expand the right columns. [cid:image001.png@01D6AE12.30A0D7A0] I got the result of the label with the label ID but now I´m lacking the label ID naming. How do I get the labelname? And how can I get other custom fields as I don´t know what their name is in the database. Thanks a lot for your support! Best regards David Von: David Serafim <notifications@github.com> Gesendet: Samstag, 24. Oktober 2020 22:40 An: davser/PipedriveTOPowerBI <PipedriveTOPowerBI@noreply.github.com> Cc: David Wolf <DW@berndwolf.de>; Author <author@noreply.github.com> Betreff: Re: [davser/PipedriveTOPowerBI] little addition to this nice piece of code (#1) Hi I'm really happy that this little code help you. I fixed the comma. Sorry for the late response. To Add more data you just need to go to [https://developers.pipedrive.com/docs/api/v1/#/] and replace "https://mypipedrive.pipedrive.com/v1/deals" by "https://mypipedrive.pipedrive.com/v1/leads" - if you want the leads for example Then in PowerBI you just inner join all of them, a bunch of this little scripts. — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub<#1 (comment)>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/AGQJQMA3S64ZMYNONUTTISTSMM3TJANCNFSM4RZZMGHA>.