Forum Discussion
reuse Project
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!
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.
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.
4 Replies
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.
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.
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.
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.
