reuse Project

[bonancio]

i'm somewhat beginner in power bi and i just finished a project for a company, now i got more companies that have the same api however with different authorization tokens which bring the information from each company. i'm struggling to find a way to like just copy the project that i finished and change the token to get the values from another company? can someone help me, plss!

[rajendraongole1 · Accepted solution]

Hi @bonancio -you can adjust the authorization tokens within the queries for each company’s API. to avoid rebuild the project from scratch.

you need to quickly switch between companies within the same report, you can create a Company Parameter in power query editor (Manage parameters >> New Parameters)  eg : "API Token" and use it to toggle between different company tokens. This involves setting up separate queries for each company’s data source and using the Company parameter to switch between them.

Ref: similar thread

PowerBI REST API & Access Token with Power Query - Microsoft Fabric Community

Hope the above information helps.

[Anonymous · Accepted solution]

Hi, @bonancio 

May I ask if you have gotten this issue resolved? If it is solved, please share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.

If it hasn't been resolved, please provide us with more detailed information about the problem you're experiencing. Please be careful to remove all sensitive information and we will do our best to provide ideas for your issue.

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Fen Ling,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[bonancio]

i think i got it, i should make a parameter where it has all the tokens and then it will change based on which company i want, is that right?

i have tried to do a table called token where i was storing the value from token and then every time i have to use it i just pulled from this table, however i tried to use a different token and the whole dash just got blank. 

[rajendraongole1 · Accepted solution]

Hi @bonancio -you can adjust the authorization tokens within the queries for each company’s API. to avoid rebuild the project from scratch.

you need to quickly switch between companies within the same report, you can create a Company Parameter in power query editor (Manage parameters >> New Parameters)  eg : "API Token" and use it to toggle between different company tokens. This involves setting up separate queries for each company’s data source and using the Company parameter to switch between them.

Ref: similar thread

PowerBI REST API & Access Token with Power Query - Microsoft Fabric Community

Hope the above information helps.

[bonancio]

i think i got it, i should make a parameter where it has all the tokens and then it will change based on which company i want, is that right?

i have tried to do a table called token where i was storing the value from token and then every time i have to use it i just pulled from this table, however i tried to use a different token and the whole dash just got blank.