Discussion Forum: All Replies to Message 1295201 |
|
|
| | Author: | Brickinbox | Posted: | Jul 15, 2021 09:09 | Subject: | Connection with PowerBI | Viewed: | 80 times | Topic: | Problem | |
|
| Hello,
I would like to make a connection between my Store and Microsoft PowerBI. I want
to use PowerBI for more details about historical orders, items I have sold and
historical prices.
I have been told the API from Bricklink uses Oauth 1.0 and in PowerBI this is
not supported. From information on PowerBI forums I understand that a connection
with Oauth1.0 is possible. Unfortunately I haven't been able to connect Bricklink
and PowerBI jet.
Does anyone have experience setting up this connection? I would like to know
what I need to do to make it work. It will be great to hear from you!
Kind regards
Lauren
|
|
| | | | | |
| | | | Author: | ErwinNL | Posted: | Jul 15, 2021 09:33 | Subject: | Re: Connection with PowerBI | Viewed: | 30 times | Topic: | Problem | |
|
| In Problem, Brickinbox writes:
| Hello,
I would like to make a connection between my Store and Microsoft PowerBI. I want
to use PowerBI for more details about historical orders, items I have sold and
historical prices.
I have been told the API from Bricklink uses Oauth 1.0 and in PowerBI this is
not supported. From information on PowerBI forums I understand that a connection
with Oauth1.0 is possible. Unfortunately I haven't been able to connect Bricklink
and PowerBI jet.
Does anyone have experience setting up this connection? I would like to know
what I need to do to make it work. It will be great to hear from you!
Kind regards
Lauren
|
I have a working javascript example for PowerBI:
https://downloads.inspacesoftware.com/public/TRBrickLinkAPIshare.ktr
Made and tested together with another seller (Paul).
|
|
|
| | | | | | | | | |
| | | | | | Author: | leggodtshop | Posted: | Jul 15, 2021 09:35 | Subject: | Re: Connection with PowerBI | Viewed: | 25 times | Topic: | Problem | |
|
| In Problem, ErwinNL writes:
| In Problem, Brickinbox writes:
| Hello,
I would like to make a connection between my Store and Microsoft PowerBI. I want
to use PowerBI for more details about historical orders, items I have sold and
historical prices.
I have been told the API from Bricklink uses Oauth 1.0 and in PowerBI this is
not supported. From information on PowerBI forums I understand that a connection
with Oauth1.0 is possible. Unfortunately I haven't been able to connect Bricklink
and PowerBI jet.
Does anyone have experience setting up this connection? I would like to know
what I need to do to make it work. It will be great to hear from you!
Kind regards
Lauren
|
I have a working javascript example for PowerBI:
https://downloads.inspacesoftware.com/public/TRBrickLinkAPIshare.ktr
Made and tested together with another seller (Paul).
|
QFT. Using the Pentaho PDI tool. It could work. If you retrieve all data into
json-files locally and work with PowerBI on those json-files?
|
|
|
| | | | | | | | | | | | | |
| | | | | | | | Author: | ErwinNL | Posted: | Jul 15, 2021 09:39 | Subject: | Re: Connection with PowerBI | Viewed: | 24 times | Topic: | Problem | |
|
| In Problem, patpendlego writes:
| In Problem, ErwinNL writes:
| In Problem, Brickinbox writes:
| Hello,
I would like to make a connection between my Store and Microsoft PowerBI. I want
to use PowerBI for more details about historical orders, items I have sold and
historical prices.
I have been told the API from Bricklink uses Oauth 1.0 and in PowerBI this is
not supported. From information on PowerBI forums I understand that a connection
with Oauth1.0 is possible. Unfortunately I haven't been able to connect Bricklink
and PowerBI jet.
Does anyone have experience setting up this connection? I would like to know
what I need to do to make it work. It will be great to hear from you!
Kind regards
Lauren
|
I have a working javascript example for PowerBI:
https://downloads.inspacesoftware.com/public/TRBrickLinkAPIshare.ktr
Made and tested together with another seller (Paul).
|
QFT. Using the Pentaho PDI tool. It could work. If you retrieve all data into
json-files locally and work with PowerBI on those json-files?
|
My total bad to the topic starter, this is indeed Pentaho PDI!
PowerBI doesn't support oAuth.
|
|
|
| | | | | |
| | | | Author: | leggodtshop | Posted: | Jul 15, 2021 10:11 | Subject: | Re: Connection with PowerBI | Viewed: | 30 times | Topic: | Problem | |
|
| In Problem, Brickinbox writes:
| Hello,
I would like to make a connection between my Store and Microsoft PowerBI. I want
to use PowerBI for more details about historical orders, items I have sold and
historical prices.
I have been told the API from Bricklink uses Oauth 1.0 and in PowerBI this is
not supported. From information on PowerBI forums I understand that a connection
with Oauth1.0 is possible. Unfortunately I haven't been able to connect Bricklink
and PowerBI jet.
Does anyone have experience setting up this connection? I would like to know
what I need to do to make it work. It will be great to hear from you!
Kind regards
Lauren
|
It looks like you will need a Data Connector.
https://github.com/Microsoft/DataConnectors
|
|
|
|
|
|