powerbi

226 Topics

POWERBI Subscription
Hi, I have a Power BI report where a Navigation Page serves as the landing page, and all other data pages are hidden to ensure users follow a specific flow. I want to create an email subscription for one of these hidden pages. However, because the pages are hidden, they do not appear in the 'Report Page' dropdown menu during setup. Consequently, the subscription defaults to sending the Landing Page instead of the intended report page. Thanks.
Solved
Anitha__A
4 days ago Place Report Server
4KViews
0likes
6Comments
How to get what app audience(s) do users exist under
I need to determine which app audience(s) our users belong to within Power BI. Specifically, I’m looking to get a list of audiences for each Power BI app so we can verify user access. Can you advise on how to retrieve this information, or share the best method to export the app audience details?
Solved
smanda
26 days ago Place Report Server
225Views
0likes
5Comments
API of Cloud Compliance Violation Dashboard
Hi Team, Could you provide the API of "Cloud Compliance Violation Dashboard" for reporting automation poplation ? Name Cloud Compliance Violation Dashboard Location CLOUD-COMPLIANCE-DASHBOARD-PROD Login link https://app.powerbi.com/groups/35c06fca-e342-4e3a-afa0-47f407256378/reports/fc0a8d06-b910-470e-8425-c25b6ceb7a0c/ReportSectionc8f0906865a30d1a5135?experience=power-bi&clientSideAuth=0
Solved
43598355
26 days ago Place Report Server
246Views
0likes
3Comments
Exploring Clickable Manager Navigation Instead of Drillthrough
Hi, I've created a mock-up of a potential navigation experience for the AI Adoption Dashboard. The idea is that instead of using Drillthrough (which may be difficult to explain and adopt for leaders/managers), we make the Manager Name clickable, similar to a button or hyperlink. When a user clicks a manager, it would navigate to a dedicated manager details page showing: The selected manager's organization/team only A similar matrix view (without the leader slicer) Tool adoption counts and percentages Additional visuals such as bar charts showing adoption by AI tool Any relevant team-level insights The goal is to provide a more intuitive "click and explore" experience that f eels like navigating through the organization hierarchy, rather than requiring users to understand Drillthrough functionality. Would this type of page navigation be technically feasible in Power BI? Thank you for you help in advance
Solved
puneethjp
2 months ago Place Desktop
559Views
0likes
5Comments
PowerBI Workspaces
I am sure that this has been asked a few times, and while I am searching for solutions, I thought that I would post this scenario/question here, looking for comments/solutions/how you are doing things similar/etc. We have different Business groups creating PowerBI reports/dashboards for their end consumers. We (as in the company's IT group) are trying to "reel" in the creation of reports/dashboards and create a deployment workflow that we can share with leadership. To stop the "Wild West" type of approach to Business users. With different groups "developing" PowerBI reports/dashboards, what is the process that you and your company use? We have thought about incorporating each Business Group their own PowerBI workspace to work with, then have a consolidated workspace, then have each PowerBI developer check in/out their PowerBI "code" into a code management solution (similar to TFS or ADO), then have a "TEST" environment, once the PowerBI "code" is "blessed", promote it to a "PROD" environment for consumers to use (view reports/dashboards, etc). Is this the correct way of thinking? How are you and your company working similar to this process now? And, is it successful, what would you update? Thank you
Solved
pokesfan_72
2 months ago Place Report Server
1.1KViews
0likes
5Comments
Paginated Report
Hello everyone, I have a Paginated Report that works just fine on the Desktop App but if i publish the report to the powerbi Service and want to use it, i get the error message, "Unable to render paginated report A data source used by this report returned an error. Received error payload from gateway service with ID 57703: Async operation a1ee1d60-b03b-4159-b802-8d902e4eef69 is faulted with [0]Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.AdomdDataAccessErrorResponseException: AdomdException encountered while accessing the target data source. GatewayPipelineErrorCode=DM_GWPipeline_Gateway_DataSourceAccessError GatewayVersion=3000.242.9 ErrorCode=-1056308850 ---> [1]Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.GatewayPipelineWrapperException: Substituted: AdomdErrorResponseException:The specified query is too complex to be evaluated as a single statement. GatewayPipelineErrorCode=DM_GWPipeline_UnknownError GatewayVersion=3000.242.9 InnerType=AdomdErrorResponseException InnerMessage=The specified query is too complex to be evaluated as a single statement. InnerToString=Microsoft.AnalysisServices.AdomdClient.AdomdErrorResponseException: The specified query is too complex to be evaluated as a single statement. " I get the error message when i select my filters and then click on view report. If i want to get only one customer at the filter the reports works but when i want to see all customers at one i get the error. In the Desktop App "Power BI Report Builder" i dont get this issue at all. How can i resolve this error? Any suggestions?
LaurenzR
3 months ago Place Report Server
2.3KViews
0likes
17Comments
Hierarchies in PowerBI scorecards
I am extremely disappointed to see the hierarchy feature retired in PowerBI scorecards and hope an alternative function will be developed. Hierarchies allow consistent data metrics to be used seamlessly from our C-suite to our front office at 20+ locations and are easily scalable as we grow and add new metrics.
Solved
mthomas66
5 months ago Place Desktop
873Views
1like
5Comments
Issue Exporting Power BI Paginated Report via API Using Service Principal
Hello Power BI Community, I’m currently facing an issue with automating Paginated report exports in Power BI using the REST API with a service principal. Everything seems to be working fine when I use a master user, but I’m running into issues when trying to use a service principal for the same task. Here’s a brief overview of what I’ve done so far: Set up a Service Principal in Azure Active Directory and granted it the necessary API permissions (e.g., Report.Read.All, Dataset.ReadWrite.All, etc.) for Power BI. Used the OAuth2 client credentials flow to authenticate and obtain an access token for the service principal. Successfully created a dataset using the Power BI API. Created paginated reports based on this dataset. Attempted to use the Export to File in Group API to export the report. When I try to export the report using the service principal, I’m encountering the following error: { "status": "Failed", "error": { "code": "Connection_Error_General", "message": "RootActivityId(4780ea99-6f13-4c9d-a18f-6f935b2ce05f): There was an error communicating with Analysis Services. Please verify that the data source is available and your credentials are correct.", "details": [] } } The export works perfectly fine when I use a master user for authentication, so the issue seems to be related to service principal authentication. Any help or pointers would be greatly appreciated! Thanks in advance for your help!
Solved
Rohan-Kumar
6 months ago Place Desktop
1.2KViews
1like
5Comments
HTTPS ERROR POWER BI REPORT SERVER
Colegas alquien que me pueda ayudar, Recientemente reinstale un servidor PBIRS por que la base de datos se contraba corrupta, segui los pasos en el foro para dicha reinstalacion, ahora veo que el sitio con el puerto 80 funciona, puedo organizar mis carpeta, asignar usuarios, ver informes BI, etc. Sin embargo al usar el puerto 443, puedo realizar todo ello excepto visualizar informes BI. Antes no me pasaba eso, sin embargo el servidor anterior yo no lo configure. Revise mi configuracion en report server configuration manager y al parecer todo esta bien. ¿es necesario realizar mas configuraciones en los archivos .config? esta parte aun lo lo revise. Mi version de septiembre 2025
Solved
vladimir74
6 months ago Place Report Server
812Views
0likes
3Comments
Error in scheduled refresh
Hello! I have a Power BI report connected to a SharePoint Online list. This SharePoint list receives data from a Power App, and that part works fine. However, when new data is added to the SharePoint list, the Power BI report does not update automatically. I created a Power Automate flow to refresh the dataset whenever a new item is created, and the flow shows as successful, but the data in Power BI does not refresh. Additionally, in the semantic model, the Refresh button is disabled, and I see this message: "Due to consecutive errors, scheduled refresh has been disabled. Please resolve the error on the dataset and then re-enable. Data source for Query1." I’m not sure what the error could be. Could you please help me identify and resolve this issue? Thank you!
Solved
Isajp2002
8 months ago Place Report Server
1.9KViews
0likes
3Comments