Forum Discussion
Utilizing a shared dataset from Power BI Service?
Hey all - I have a coworker that created a report, published to his workspace, then shared the report and dataset with me. Pretty sure he gave me admin rights. My team is looking to use some of the data he was able to collect to enhance our report project.
This report is refreshed manually because he does not have a VM yet. He did all of his API calls in Python and just hits the refresh button once day. I know recently, Power BI has given us the capability of connecting to a shared dataset via Direct Query when in Power BI Desktop.
If I do this, and publish report to my own App, the refreshes are not synced with the original dataset. It's dependent on him pushing that refresh button. Instead, should I connect to Power Platform 'Power BI Dataset' in the get data selection? This is what I've seen in Microsoft Documentation.
Or would it just be easier to use Microsoft Graph API to pull the table in Power BI service? Would appreciate any advice here.
Thank you!
3 Replies
Anonymous doesn't matter whatever you do, dependency is on the python script that pulls the data. You can always connect to the file where he drops the file after script but again it all depends on when the python script runs.
✨ Follow us on LinkedIn
Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
Anonymous does he refreshes the data in Power BI Desktop and then republish the report with the latest data or he refreshed in the service?
