search

davser / PipedriveTOPowerBI

13 stars 12 forks source link

little addition to this nice piece of code #1

Open cheludo opened 4 years ago

cheludo commented 4 years ago

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 commented 3 years ago

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 commented 3 years ago

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 GitHubhttps://github.com/davser/PipedriveTOPowerBI/issues/1#issuecomment-716052320, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AGQJQMA3S64ZMYNONUTTISTSMM3TJANCNFSM4RZZMGHA.