search

davser / PipedriveTOPowerBI

13 stars 12 forks source link

How can I insert new columns in the code #3

Open Pedro-Dellazzari opened 3 years ago

Pedro-Dellazzari commented 3 years ago

The code works perfectly, thank you very much.

But I wanted to add new columns for the analysis, such as business owner, status and date of gain or loss. Could you help me with that?

I don't know that much about M.

(Sorry for English)

byrongdrums commented 2 years ago

I have the same issue, did you solve the problem? @Pedro-Dellazzari

akrogv commented 1 year ago

In order to add new columns for the analysis, first you should study the API documentation (https://developers.pipedrive.com/docs/api/v1) and see what endpoints should you use in order to retrieve that data.

There are different endpoints for which you will retrieve the data. Just change your URL to the correct endpoint and connect to PowerQuery. Then, model within Powerquery.

If you still need help I will be happy to help with the endpoints.