Forum Discussion
Is it Possible To automatically get information FROM POWER BI service as viewer?
there is a report which i have permission to read. i have to apply some filters and then export the data from visual. so i do this every month.
i want to automate this task. how i can do it?
Hi Lemiodas,
Thanks for the follow-up question.
As per Microsoft documentation, Power Automate uses the Export to File API to export Power BI reports, which requires the workspace to be backed by Premium or Fabric capacity. Since this process interacts programmatically with Power BI artifacts, it also requires appropriate permissions on the underlying dataset. With Viewer (read-only) access alone, this type of automation isn’t supported. You would need Build permission on the dataset (or higher access) to achieve this.Please refer to the official documentations:
1.Export Power BI embedded analytics reports API - Power BI | Microsoft Learn
2.Export and Email a Report with Power Automate - Power BI | Microsoft Learn
I hope this information helps. Please do let us know if you have any further queries.
Thank you.
5 Replies
v-abhinavmuCommunity Support
Hi Lemiodas,
Thanks for reaching out to the Microsoft Fabric Community forum.
With Viewer (read-only) access in Power BI Service, it is not possible to automate the process of exporting filtered data from a report. This is because automation scenarios such as APIs or Analyze in Excel require Build permission on the underlying dataset (semantic model). Viewer access only allows consuming reports and exporting data manually from visuals, but it does not provide the necessary permissions to access the dataset directly or automate these actions. To achieve your requirement, you would need to request Build permission from the report owner or consider alternatives such as scheduled subscriptions or Power Automate.
Please refer to the official Microsoft documentation:
1. Build Permission for Shared Semantic Models - Power BI | Microsoft Learn2. Roles in workspaces in Power BI - Power BI | Microsoft Learn
I hope this information helps. Please do let us know if you have any further queries.
Thank you.With Power autoamte i will be able to do that with only viewer access?
- v-abhinavmu
Hi Lemiodas,
Thanks for the follow-up question.
As per Microsoft documentation, Power Automate uses the Export to File API to export Power BI reports, which requires the workspace to be backed by Premium or Fabric capacity. Since this process interacts programmatically with Power BI artifacts, it also requires appropriate permissions on the underlying dataset. With Viewer (read-only) access alone, this type of automation isn’t supported. You would need Build permission on the dataset (or higher access) to achieve this.Please refer to the official documentations:
1.Export Power BI embedded analytics reports API - Power BI | Microsoft Learn
2.Export and Email a Report with Power Automate - Power BI | Microsoft Learn
I hope this information helps. Please do let us know if you have any further queries.
Thank you.
- krishnakanth240
Super User
Hi Lemiodas
As a viewer, automation options are very limited.You cannot directly automate exports from Power BI Service UI. Ask for Build permission on dataset then use Power Automate export
