data protection
255 Topics
Missing "Show data point as a table" in Power BI Service for a map visual
I have a report created in Power BI Desktop and published to the Power BI Service. The report contains a Bing map visual with bubbles sized by the number of wagons at various stations. Issue: In Power BI Desktop, when I right-click on a bubble, I see and can use the option "Show data point as a table." However, in the Power BI Service (web version), this same right-click option is missing. The context menu does not show it at all. Steps to Replicate: Publish the report with the map visual to Power BI Service. Open the report in a web browser. Right-click on a bubble on the map. Observe that the option "Show data point as a table" is absent. Additional Context: I have confirmed that this is not a report structure issue. When I download the same report from the service and open it in Power BI Desktop, the right-click option works correctly. I've also been told that this option was available in the service for this report in the past. Question: What could be the cause of this discrepancy, and is there a solution or a workaround to provide this functionality to web users? Is this a known limitation or a recent change in the service?Solved237Views1like4Comments
Copilot in embedded Power BI reports via iframe
Hello collegues, We are looking into enabling Copilot for Power BI reports embedded in our web application via iframe, but we want to make sure we test it safely before enabling anything in production. Our embedded reports are customer-facing and use Row-Level Security to keep each customer’s data separate. Some reports may also contain business data and PII. Our intended approach is to use a dedicated demo workspace, create two demo customer accounts, configure RLS so each account can only access its own customer data, and then test Copilot inside the embedded iframe report. We want to confirm that Copilot only uses data available to the signed-in user and cannot return data from another customer’s scope. We would like to understand: 1. What settings are required to enable Copilot inside embedded Power BI reports via iframe? 2. Can Copilot be enabled only for the demo workspace, selected reports, and selected demo users? 3. If we enable the required tenant/capacity data processing setting, could Copilot become available to other embedded reports or users outside the demo workspace? 4. Does Copilot fully respect RLS and Azure AD identity when the report is accessed through an embedded iframe? 5. Is this demo workspace + two demo accounts + RLS test a valid approach to verify customer data isolation? 6. Are there any additional security checks or limitations we should consider before moving to production? What is the best approach for such task? I would appreciate any help! Thanks!Solved602Views1like5Comments
Anyone know how to capture when a user triggers export in PBI Embedded?
Greetings, community. Hoping someone can help me out. We need to be able to track when a user performs an export in a PBI Embedded scenario. We are trying to leverage the native PBI export functionality but need to be able to know if/when a user actually performs the export operation. Anyone have ideas and/or has implemented this previously? RELATED THREAD: Is it possible to capture user performing Export i... - Microsoft Fabric Community856Views1like5Comments
How to Auto-Select Latest Month in Power BI Slicer (No Manual Intervention)?
**Requirement: Dynamic Default Month Selection in Power BI Slicer** I have a Power BI report with a time period slicer built on a hierarchy: **Fiscal Year → Quarter → Month** (Indian fiscal year: April–March). * The data is refreshed **monthly** * Currently, the slicer selection is being **updated manually** after each refresh --- ### **Expected Behavior** I want to make this process fully dynamic: * Whenever new data is refreshed (e.g., April data becomes available), the report should: * Automatically default to the **latest available month** in the dataset * Reflect this both in the **data displayed** and ideally in the **slicer selection** --- ### **Additional Requirements** * The logic should be **data-driven** (based on the latest available date in the fact table, not TODAY()) * **No manual intervention** should be required after refresh * Users should still be able to: * Manually select other months/quarters/years from the slicer for analysis * Reset back to the default (latest month) --- ### **Current Setup** * Date hierarchy is derived using a **Date table related to the Fact table** * No existing **“current month” or “latest month” flag** is present ---Solved905Views0likes4CommentsPower BI Premium Accessing Trino Datasets (2 Billion Rows × 3 Columns / 3 Million Rows × 800 Columns
We use Power BI Premium Gen2, connect to Trino data source via DirectQuery/Import modes, and need to access two types of data for report development. We kindly request official confirmation on the following: Dataset ①: 2 Billion Rows × 3 Columns (Narrow Table); Dataset ②: 3 Million Rows × 800 Columns (Ultra-Wide Table Does Power BI Premium officially support the access of these two datasets? Performance impacts, official risk thresholds and recommended solutions under DirectQuery/Import modes. 2 Billion Rows × 3 Columns: DirectQuery supportability, whether Import mode exceeds upper limit, and performance impacts. 3 Million Rows × 800 Columns: Whether 800 columns are supported, performance impacts, official safe column count and optimization solutions. Clarify support conclusion, performance risks, scenario-specific best practices and whether preprocessing is needed on Trino side.Solved701Views0likes3Comments
Custom visual in Power BI for integration of GPT or Gemini with Power BI
I’m working on integrating ChatGPT or Google Gemini into Power BI using a custom visual to enable interactive AI responses directly from the report, based on the dataset contents. Everything works fine when I test the API in Postman, but Power BI blocks the API call from the custom visual due to security restrictions, most likely related to Content Security Policy (CSP) or cross-origin (CORS) issues. I have Tried So Far Built a custom visual in Power BI using React and TypeScript Integrated OpenAI/Gemini API logic inside the visual Created a proxy API server to forward the API requests Used tunneling tools like: localtunnel ngrok Cloudflare Tunnel I Need Help With How can I successfully connect Power BI custom visual to OpenAI/Gemini API through a proxy or tunnel? Is there a recommended tunneling or reverse proxy approach that works with Power BI visuals? Any other approaches to solve the same problem? Any guidance or step-by-step solution would be greatly appreciated! Thanks!Solved6.3KViews0likes5CommentsHow to pass parameters from Angular to a Power BI Paginated Report (embedded in web app)?
Hi team, We have a web application built in Angular where users log in using their application credentials. Inside the app, we have a Report Center that lists all available Paginated Reports (hosted in Power BI / Fabric). Each user has a UserID in the app, and our paginated reports also have a hidden parameter named UserID. Based on this value, the report filters and cascades data (for example, to a specific Enterprise). We want to pass the UserID from Angular to the report automatically when a user clicks on a report in the Report Center. Could someone please clarify: What’s the best way to pass parameters (like UserID) from Angular to a paginated report during embedding? Are there any report-level prerequisites (e.g., parameter naming, visibility, default values)? Should we append parameters to the embedUrl (like &rp:UserID=1234) or is there a better API-supported approach? Any example code or reference documentation would be really helpful. Thanks in advance!Solved1.4KViews0likes6Comments
Power Query Defender Advanced hunting bad request 400 for some tables.
Hello i am trying to connect to Defender XRD api using a service principal authentication following the example that has been provided in MS documentation. Microsoft Defender for Endpoint APIs connection to Power BI - Microsoft Defender for Endpoint | Microsoft Learn. I am connecting from a DataFlow Gen2 in Fabric. For DeviceEvents table: let AdvancedHuntingQuery = "DeviceEvents | where ActionType contains 'Anti' | limit 20", HuntingUrl = "https://api.securitycenter.microsoft.com/api/advancedqueries", Response = Json.Document(Web.Contents(HuntingUrl, [Query=[key=AdvancedHuntingQuery]])), TypeMap = #table( { "Type", "PowerBiType" }, { { "Double", Double.Type }, { "Int64", Int64.Type }, { "Int32", Int32.Type }, { "Int16", Int16.Type }, { "UInt64", Number.Type }, { "UInt32", Number.Type }, { "UInt16", Number.Type }, { "Byte", Byte.Type }, { "Single", Single.Type }, { "Decimal", Decimal.Type }, { "TimeSpan", Duration.Type }, { "DateTime", DateTimeZone.Type }, { "String", Text.Type }, { "Boolean", Logical.Type }, { "SByte", Logical.Type }, { "Guid", Text.Type } }), Schema = Table.FromRecords(Response[Schema]), TypedSchema = Table.Join(Table.SelectColumns(Schema, {"Name", "Type"}), {"Type"}, TypeMap , {"Type"}), Results = Response[Results], Rows = Table.FromRecords(Results, Schema[Name]), Table = Table.TransformColumnTypes(Rows, Table.ToList(TypedSchema, (c) => {c{0}, c{2}})) in Table The request suceed to connect with no issues. For EmailEvents table However when i try to change the query in the AdvancedHuntingQuery Step: let AdvancedHuntingQuery = "EmailEvents | limit 20", HuntingUrl = "https://api.securitycenter.microsoft.com/api/advancedqueries", Response = Json.Document(Web.Contents(HuntingUrl, [Query=[key=AdvancedHuntingQuery]])), TypeMap = #table( { "Type", "PowerBiType" }, { { "Double", Double.Type }, { "Int64", Int64.Type }, { "Int32", Int32.Type }, { "Int16", Int16.Type }, { "UInt64", Number.Type }, { "UInt32", Number.Type }, { "UInt16", Number.Type }, { "Byte", Byte.Type }, { "Single", Single.Type }, { "Decimal", Decimal.Type }, { "TimeSpan", Duration.Type }, { "DateTime", DateTimeZone.Type }, { "String", Text.Type }, { "Boolean", Logical.Type }, { "SByte", Logical.Type }, { "Guid", Text.Type } }), Schema = Table.FromRecords(Response[Schema]), TypedSchema = Table.Join(Table.SelectColumns(Schema, {"Name", "Type"}), {"Type"}, TypeMap , {"Type"}), Results = Response[Results], Rows = Table.FromRecords(Results, Schema[Name]), Table = Table.TransformColumnTypes(Rows, Table.ToList(TypedSchema, (c) => {c{0}, c{2}})) in Table i am getting a Web.Contents failed to get contents from 'https://api.securitycenter.microsoft.com/api/advancedqueries?key=EmailEvents%7C%20limit%2020' (400): Bad Request. Any help is appreciated in explaining or solving the issue is well appreciated. ThanksSolved9.5KViews0likes7CommentsExporting PBI Page to PDF with Power Automate
Hello, I have a use case in which I need a defined group of users to be able to have view access to a Power BI report which will contain the Power Automate button visual to trigger a flow. This flow will export a defined page (which will be hidden) to PDF. Afterwards, the flow should send an email to the user containing the exported PDF file. I have tried testing the flow and it works perfectly as long as the user has access to the workspace the PBI report is published in. However, once the access to the workspace is removed (maintaining read only access to the report), it breaks, returning the following error: {"error":{"code":"PowerBINotAuthorizedException","pbi.error":{"code":"PowerBINotAuthorizedException","parameters":{},"details":[],"exceptionCulprit":1}}} I imagine this has to do with the permissions concerning the workspace access. However, I am confused because a coworker who was working on a different project managed to achieve what my time is trying to do, but instead of integrating the button within Power BI, their Power Automate flow is triggered via a button in a Power Apps application (more specifically, the button triggers a flow which exports the pdf of a paginated report from a report and saves it in a sharepoint folder the user has access to). I am wondering why I get the permissions error in my case, but in my coworker's case it works? And/or if anyone has any workarounds to my problem? Thanks in advance.Solved1.3KViews0likes4Comments
List all connections for all users
Hello, Is there a way for an administrator to get a list of all Connections established in a capacity? We would like to audit all connections and their user permissions. We've found that admins can only see connections that have been shared with them or they have created. This leaves potential for connections not visible to our audit process. How can we see all connections, irrespective of sharing? Thank you.Solved2.7KViews0likes9Comments