GENESIS-Online is the data portal of the Federal Statistical Office of Germany (Statistisches Bundesamt).   Problem Since Destatis shut down the option to send GET-requests to their API, it is now impossible to get data from the API into Excel or PowerBI without using a custom connector.  The core of the problem is that the way authentication via "content" in a POST request is not allowed from PowerQuery Web.Contents (that is how Genesis demands the auth) and HTTPS-authentication is not supported by the Genesis Web API (that seems to be what is supported by Microsoft).   Solution There are only two viable solutions to this from a enduser perspective: Either Destatis or Microsoft changes the way authentication works to allow for Web.Contents to work  or Destatis develops and issues a certified connector via Microsoft.   Code-Example that worked until GET was removed from the API   let URL = "https://www-genesis.destatis.de/genesisWS/rest/2020/data/table?" & Uri.BuildQueryString( [ username = "YourUsernameOrToken", password = "YourPasswordOrEmptyWhenToken", name = "61111-0002", area = "all", compress = "false", startyear = "2020", endyear = "2023", regionalvariable = "", regionalkey ="", classifyingvariable1="", classifyingkey1="", classifyingvariable2="", classifyingkey2="", job = Text.From(false,"en-US"), stand="", language="de" ]), Quelle = Json.Document(Web.Contents(URL)), Object = Quelle[Object], Content = Object[Content], Tbl = Csv.Document(Content,[Delimiter=";", Columns=5, Encoding=65001, QuoteStyle=QuoteStyle.None]) in Tbl     ... View more

Hi Geek, I hope you are doing well. In our organization, we currently maintain over 400 SSRS reports. We have decided to migrate these reports to Power BI Service in order to achieve better visualization and interactivity, centralized access and governance, and reduced maintenance efforts. During the migration process, I observed that while we can publish multiple reports in bulk using a PowerShell script, each report still requires manual Gateway/Cloud connection mapping. Given the scale of 400+ reports, this approach is extremely time-consuming and impractical to manage. We are looking for a solution or workaround that would allow us to: Publish all SSRS (paginated) reports in bulk Configure the data source connection once and apply it across all reports Eliminate the need for manual intervention on each report As part of my research, I created a workspace (where I have admin access) and developed a PowerShell script using REST APIs. While the RDLs are publishing smoothly, the data source connection mapping still requires manual effort. Could you please advise if this can be achieved natively within Power BI Service, or if there are any recommended tools, scripts, or best practices to help automate this process? Your guidance will be greatly appreciated. ... View more

I wound love to have a measure to check which bookmark is being used now.  f.e. Names of bookmark : " ALL data", " Europe data", "USA data" measure: BOOKMARKNAME() turns the name of active bookmark.      ... View more

Tracking Interactions with the ArcGIS Map Visual in Power BI Currently, it is not possible to track user interactions on a specific visual (such as the ArcGIS Map visual) using Power BI’s built-in features. Power BI’s usage tracking tools operate at higher levels (report, dashboard, and page), not at the individual visual level. Report/Dashboard Usage Metrics: Power BI usage metrics reports provide data on how often a report or dashboard is viewed, who viewed it, and even which pages were viewed, but they do not record interactions with specific visuals on those pages. In other words, you can see if a user opened or viewed a report (and which page they looked at), but you cannot see if they clicked or interacted with an ArcGIS Map visual on that page. This is confirmed in Microsoft's documentation and community discussions: the built-in metrics “don’t give visual-level detail.” [Re: Tracki...rosoft ...], [Monitor re...soft Learn] Capacity Metrics: If you are using Power BI Premium (Fabric), the capacity metrics app or dashboard provides information about overall resource usage (CPU, memory, query durations, etc.) on your capacity. While this can help identify heavy usage times or performance bottlenecks, it does not track individual user clicks or visual interactions. At best, capacity metrics and audit logs can give an aggregate sense of activity (e.g. report render timings, session counts), but not the fine detail of which visual was clicked. [Re: Tracki...rosoft ...] Audit Logs: The Office 365 Audit Logs for Power BI record events like view, export, share, delete, etc., on Power BI artifacts. For example, audit logs can tell you which user viewed which report and when, or if someone exported data from a visual. However, audit logs do not capture general interactivity like filtering or clicking on a visual. They log discrete events (such as “Viewed a report” or “Exported data from ArcGIS Map visual”), but simply clicking or selecting within a visual isn't logged as a separate event. There is no out-of-the-box telemetry for “user hovered over X” or “user zoomed a map.” In summary, Power BI provides metrics at the content level (reports/dashboards/pages) but does not support tracking interactions on an individual visual like the ArcGIS map. This limitation is by design for now. Please fix this limitation to gain additional insights to usage metrics of ArcGIS map visual ... View more

Currently, the tenant setting for ArcGIS Maps for Power BI is a simple on/off setting for the entire organization – there is no built-in capability to target specific security groups or users with this setting. In the Power BI Admin Portal, the option is labeled “Use ArcGIS Maps for Power BI” and can only be toggled enabled or disabled globally. When enabled, it allows all users in the tenant to use the ArcGIS visual; when disabled, nobody in the tenant can use it. There isn’t a mechanism to enable it for some users and not others   Please refer to https://learn.microsoft.com/en-us/fabric/admin/service-admin-portal-integration ... View more

It would be extremely helpful if Power BI could expose / read the current app audience context to the data model, allowing report authors to use DAX to dynamically filter or customize visuals based on the audience a user is viewing the app through.   This would enable more personalized experiences and tighter integration with RLS and user-based logic and would be easier to manage than RLS alone.    When the current Audience is accessible / readable in the Power BI context I can build Audience specific filters. The idea is that all users in an Audience can see certain records in a data table and users in a different audience can not. The advantage over pure RLS is that I need to manage the users only once - when I put them into an Audience. ... View more

A built-in visual showing end-to-end data flow: dataset → report → visuals. ... View more

Requesting you to develop options such as allowing to change a tab (Sheet name tab) colour change. It will be helpful to have different colors visual tabs ... View more

If a mobile layout has been created, a user should see the mobile version when visiting a dashboard from a mobile device.  This would increase use of dashboards, particularly by executives who may want a quick check and aren't inclined to install yet another app. ... View more

Allow developers to set the default filters based on Row Level Security.  For example, managers in Sales would see sales numbers for their region and could also look at other regions or the overall for context.   This is something we've been struggling with for a while, especially for VPs who do not want to set multiple filter selections just to see their main info every time. ... View more

I’d like to request the addition of support for custom HTTP request headers in Power BI Report Builder, similar to what is already available in Power BI Desktop. Currently, when connecting to APIs in Power BI Report Builder, there is no option to include request headers (for example, Authorization: Bearer <token>). This limitation makes it impossible to connect to APIs that require authentication, which is a very common use case. In contrast, Power BI Desktop already provides this capability, making it much easier to work with APIs that need authentication or other custom headers. ... View more

I store some things in Dev like utility notebooks and true under development projects, and keep them in folder like DO NOT PUSH. Was looking to have the ability to toggle visibility to the comparison in deployment pipelines to make comparison faster. Could be folder specific, or object specific, I don't care which.   Thanks! ... View more

Context: Company I am in recently started using Power BI Desktop after months of gruelling TDA approvals and sign-offs to acquire the tool. Company uses other BI tools but mainly promotes Power BI Desktop and one other tool as there main BI tools. The company does allow self-service capabilities versus a sole team providing reporting for all others within the company. A user recently found out that Power BI Desktop lacks auditing and because of data governance within the company, this has caused the company to take drastic measures, including but not limited to removing access to Power BI Desktop across the company (for users that have the tool) although a lot of the departments using Power BI have heavily invested in the tool.   Problem: So as some of you may have seen/experienced, there is no native auditing of the Power BI Desktop tool itself (much like Microsoft Excel). While you do have Audit Logs within Power BI Service, there is nothing that tracks in-app changes for all users using Power BI Desktop where users have not published a report. As such, as long as users have the relevant credentials and access, they could potentially connect to any datasource they want to (within the tool) with potentially no view of this (certain datasources may let you audit who has access the source and how, but if the source isn't used within the company then there is no view of this). This also means that users could store files locally where they have connected to data sources that they were not supposed to be connecting to; they could connect to a data source very briefly and close the tool, after not doing anything else.   Solution: Essentially a tool that tracks in-app changes of Power BI Desktop users within a company. This would allow the company to gain metrics on how Power BI Desktop is being used and what users are connecting to regardless of whether it has been saved loaclly or accessed on a one-time occassion.  ... View more

n Microsoft Fabric, capacity management is currently manual or script-based, which can be inefficient and costly for organizations with predictable or intermittent workloads. I propose adding native auto-pause and auto-scale capabilities for Fabric capacities (e.g., F64, F2) based on usage patterns or scheduled time windows. This would allow tenants to: Automatically pause capacities when idle (e.g., nights, weekends). Automatically scale down to lower SKUs (e.g., F2) when usage is low. Automatically scale up when usage increases or during business hours. Receive cost-saving recommendations based on historical usage. This feature would help optimize resource usage, reduce costs, and simplify administration — especially for Fabric-only tenants or those with predictable workloads.   Benefits Cost savings for organizations Reduced need for custom automation scripts Improved governance and control Aligns with Azure’s existing autoscaling capabilities   ... View more

Currently notebook's in fabric are unable to connect to Postgres DB on a V-net. We would love to see see this supported by fabric notebooks in order to improve development flows.       ... View more

Microsoft support says that currently the Power BI REST API to Cancel a Dataflow does not work for Gen2. I would like this feature to be available. ... View more

Search button parameter lock/save especially when changing one paremeter ex. date  ... View more

Hi, At the moment there is no way to export the people with permissions for a report / workspace. At least for now I do not have this option and getting a list a copy/paste is needed, but it's quite cumbersome to do all the cleaning, and even the whole list can not be copy-pasted at the same time. Enabling this would make the maintenance of the list way faster and simpler. ... View more

I have numerous matices and tables in a large PowerBI report aggregating loan data in many ways.  It would be great to add a simple visual calc item to simply put the current row # on each row without having to write a bunch of ranking dax measures.  anyway ranking measures wouldn't work for me - I want the row # listed to show position in the matrix or table respective of the visual itself, not by ranking the actual data.  so not matter how the data is sorted, the first row always shows 1, second row 2, etc.  This is simply to provide reference numbers to the audience viewing the report.  anybody have any ideas?   Or if this exists somewhere please let me know! ... View more