Forum Discussion
Dax query dependency
Hi Anonymous,
As you mentioned each report belongs to different datasets and their owners are also different here are the workarounds which may work for your requirements.
- You can avoid using DAX by leveraging SQL queries or Direct Query mode. If your datasets are stored in SQL or another common database. Then, write reusable SQL queries or views to dynamically calculate key performance indicators (KPIs). Use Direct Query mode in Power BI to connect directly to the database.
- Paginated Reports enable dynamic data retrieval from multiple datasets. To create these reports, first install Power BI Report Builder. Then, connect directly to multiple datasets within the report builder. Use parameters to dynamically fetch key performance indicators (KPIs) from these datasets.
If this post helps, please give us Kudos and consider Accept it as a solution to help the other members find it more easily.
Best Regards,
Sahasra.
Hi @s0m0ffc,
May I ask if you have gotten this issue resolved?
If it is solved, please mark the helpful reply or 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.
Regards,
Sahasra.
Hi Anonymous,
Since we haven't heard back from you yet, I'd like to confirm if you've successfully resolved this issue or if you need further help?
If you've already resolved the issue, you can mark the helpful reply as a "solution" so others know that the question has been answered and help other people in the community. Thank you again for your cooperation!
Thankyou.