Forum Discussion
Automated Dataset Download from Power BI Service After Refresh
Can we download a dataset from Power BI Service without using Power Automate, and download it after the scheduled refresh?
I have a requirement from a client in Power BI to automatically download the dataset when it is refreshed. They have given me access to the Power BI Service. How can I do that?
Hi shon_tytus
Thank you for reaching out Microsoft Fabric Community Forum.
If you only have access to Power BI Service, your options are limited. If the dataset is in a Premium Workspace, you can use XMLA Endpoints to connect and extract data with tools like SSMS, Python, or Power BI Desktop. If it’s not in Premium, there’s no direct way to download the full dataset automatically, but you can manually export data from reports (with row limits) or use Analyze in Excel if enabled. If scripting is allowed, you can try the Power BI REST API (requires setup). If Power Automate is available, it’s the easiest way to automate exports.
If this solution helps, please consider giving us Kudos and accepting it as the solution so that it may assist other members in the community
Thank you.
6 Replies
Hello Shon,
You can approch any one options
-if you don’t have Power BI Premium, use XMLA endpoints to extract data instead.
-If you need a no-code solution, Power Automate is the easiest option.
-Python/PowerShell scripts can automate the dataset download and integrate with other workflows
you explore this blong https://community.fabric.microsoft.com/t5/Service/Export-Underlying-Data-Once-Dataset-is-refreshed/m-p/2547743
Thanks,
PankajIf this solution helps, please accept it and give a kudos, it would be greatly appreciated.
Hi Pankaj,
My actual requirement is to automatically download the full dataset from the Power BI service when the data is refreshed, and I only have access to the Power BI service. What is the best way to achieve this?
Hi shon_tytus
Thank you for reaching out Microsoft Fabric Community Forum.
If you only have access to Power BI Service, your options are limited. If the dataset is in a Premium Workspace, you can use XMLA Endpoints to connect and extract data with tools like SSMS, Python, or Power BI Desktop. If it’s not in Premium, there’s no direct way to download the full dataset automatically, but you can manually export data from reports (with row limits) or use Analyze in Excel if enabled. If scripting is allowed, you can try the Power BI REST API (requires setup). If Power Automate is available, it’s the easiest way to automate exports.
If this solution helps, please consider giving us Kudos and accepting it as the solution so that it may assist other members in the community
Thank you.Hi shon_tytus
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.
Hi shon_tytus
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.Hi shon_tytus
I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.
Thank you.
