Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello, I'm fairly new to Power BI
I'm creating a dashboard on Power BI desktop that has to receive information from other different reports created from different people. Basically all the information I need to retrieve are tables from these other reports, and I use them to build visuals on my own dashboard. Currently I follow these steps:
1)Acces the different reports Ihave to gather information from and export one by one the tables that I need to get from them to excel
2)Stack these exported tables into one central excel file that I am using as my "database"
3)Create my visuals on the dashboard using this "database"
I have to update this dashboard daily (sometimes more than once), which means that I have to repeat this process of extraction many times.
Is there a way I could automate this information exportation to excel?
Thanks in advance!
Hi, @Anonymous
If you have access to the data sources of other different reports, you may connect to data sources with a pbix file. If you're on premium, you could write an integration outside of Power BI that generates a query using the XMLA endpoint and then sends it on somewhere else.
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Are these different power BI reports(pbix) from which you are downloading this data ?
Yes, they are different pbix reports.
@Anonymous it is not very clear what you are trying to achieve. Read this post to get your answer quickly.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
85 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |