Currently, the only way to establish a connection to Analysis services through the Power BI Gateway is by granting the user used in the gateway connection admin rights on Analysis Server (Manage SQL Server Analysis Services data sources - Power BI | Microsoft Learn). For any other datasource (Oracle, SQL, SAP, ...) this is not required.  If the Analysis Server is managed by another team, they are very reluctant (not to say refusing) to grant this extensive authorization for what in essence should only be a 'readonly' access. I strongly suggest to review this set-up and improve the interoperability between in-house applications.  ... View more

Dear Product Group,   Right now, the "shared with me" section only shows PBI items.  This is a major limitation since there are many other objects in the Fabric Eco-System.  See MS Learn for limitations.     Recently, I was asked by a collegue for a demo on Sharing.  The image below shows the adventure works warehouse was shared by john@craftydba.com to batman@craftydba.com.     If we use the link, we have access to the object.  However, logging off and logging on will loose this link.     As you can see below, the link does not show up as stated in the "shared by me" section.     The current work around is to favorite the share.  A better solution is to add the ability to see all Fabric Objects in this section.     Please put it on the roadmap to add this simple functionality to the product.   Sincerely   John Miner   ... View more

I set up a Dataflow with a Destination to a Warehouse. That warehouse has a new schema. I want my Dataflow Destintion to CREATE a table in the new schema. I specify the new table name as <schema>.<table>. What I GET is a table in the dbo schema named dbo.<schema.table>. Now, I can fix this nonsense with simple T-SQL commands so that the table is named appropriately and in the correct schema. I then accidently ran the Dataflow again without changing the Destination. I now have TWO tables in the database: <schema>.<table> and dbo.<schema.table>. OK, my fault. But if, at this point, I go back to the Dataflow to fix the destination and specify an EXISTING table in the Warehouse, I see TWO Object that *look* identical.    PLEASE make Warehouse Destinations in Dataflows such that it displays the table name AND schema name, AND make so that I am NOT forced to make New Table Destinations in the dbo schema. The New Table dialog option should allow you to specify the schema. ... View more

FinanceDemo – 5-Minute Low-Code Finance Demos with Microsoft Fabric Hi Community, I have put together a small FinanceDemo repo to help finance professionals and Fabric beginners explore Workspaceswith simple, hands-on examples. 📂 What’s inside: A tiny Excel dataset (FinanceDemo.xlsx) with Transactions + Budget 5 quick demos (all under 5 minutes): 1️⃣ End-of-Month Automation (no code, pipelines + OneLake) 2️⃣ Budget vs Actual (DAX) 3️⃣ Month-over-Month Growth (DAX) 4️⃣ SQL – Monthly Aggregation 5️⃣ Notebook – Budget vs Actual (Python) 📊 Outputs include: Budget vs Actual visuals, MoM growth %, SQL aggregation results, and notebook charts. 👉 Repo here: Finance-Fabric-Demos 💡 Why Workspaces? Everything runs directly inside your Fabric Workspace — upload the dataset once, then try DAX, SQL, and Notebooks in the same environment. Perfect for quick demos, learning, or introducing finance teams to Fabric without advanced coding. Would love feedback and suggestions — especially on extending these mini demos into more advanced workspace pipelines. 👨‍💻 Created by: Olufemi Olamoyegun, FMVA®, Microsoft Certified: Fabric Analytics Engineer Associate ... View more

Similarly to item lienage for models and dataflows in workspace, can we see what connections and datasources in the gateway and connections view are impacting. I have a lot of similar connections and would make it easier to get rid of duplicate ones. ... View more

It would be extremely helpful to have the ability to see who is currently viewing a report in real time — similar to how Looker supports active session tracking. This feature is essential for operational dashboards, collaborative environments, and live monitoring scenarios. Current usage metrics only show historical access, which is not sufficient for many real-time use cases. Why it's important: Enables better collaboration Supports live monitoring and troubleshooting Improves governance and user engagement tracking Already available in competing platforms like Looker ... View more

In Power BI Desktop, Report view when making font size changes to a table visual sometimes the values do not change straight away. A lot of the time one adds a table visual to a report.  The default font size is 10 for column headers and values.  Invariably one changes to the lowest font (size 😎 to cram more data to 'visualise' and reduce scrolling.     Link from forums  table visual. font size not always changing for column headers or values ... View more

💰 FinanceDemo – 5-Minute Low-Code Finance Demos with Microsoft Fabric Hi Community, I have put together a small FinanceDemo repo to help finance professionals and Fabric beginners explore Workspaceswith simple, hands-on examples. 📂 What’s inside: A tiny Excel dataset (FinanceDemo.xlsx) with Transactions + Budget 5 quick demos (all under 5 minutes): 1️⃣ End-of-Month Automation (no code, pipelines + OneLake) 2️⃣ Budget vs Actual (DAX) 3️⃣ Month-over-Month Growth (DAX) 4️⃣ SQL – Monthly Aggregation 5️⃣ Notebook – Budget vs Actual (Python) 📊 Outputs include: Budget vs Actual visuals, MoM growth %, SQL aggregation results, and notebook charts. 👉 Repo here: Finance-Fabric-Demos 💡 Why Workspaces? Everything runs directly inside your Fabric Workspace — upload the dataset once, then try DAX, SQL, and Notebooks in the same environment. Perfect for quick demos, learning, or introducing finance teams to Fabric without advanced coding. Would love feedback and suggestions — especially on extending these mini demos into more advanced workspace pipelines. 👨‍💻 Created by: Olufemi Olamoyegun, FMVA®, Microsoft Certified: Fabric Analytics Engineer Associate ... View more

I am having an issue where everytime I export my PowerBI to a PDF, it includes a white border around every slide making it look a bit off. It would be nice if there was an option to export it without that white border. ... View more

Muy buen día. Desde hace varios días he estado trabajando con scripts en Python y R dentro de Microsoft Power BI, logrando visualizaciones realmente potentes. Esta integración me dio mucha alegría, ya que combinar Python con Power BI abre posibilidades analíticas muy avanzadas. Sin embargo, me encontré con una limitación inesperada: los scripts de Python no son compatibles con la versión web de Power BI. Esto significa que los dashboards generados con Python no pueden visualizarse en línea como normalmente se hace con Power BI, lo cual fue una gran decepción. Power BI es una herramienta robusta y versátil, por lo que resulta extraño que no soporte esta funcionalidad en su versión web. Esta restricción limita su utilidad, especialmente para quienes desarrollamos soluciones pensadas para múltiples usuarios. Al final, los verdaderos usuarios —aquellos que consultan dashboards de forma recurrente— no utilizan Power BI Desktop, sino la versión web. Por eso, mi sugerencia para el equipo de Microsoft Power BI es clara: sería un gran avance permitir la ejecución de scripts en Python y R directamente en la web. Esto potenciaría aún más la herramienta y permitiría compartir visualizaciones avanzadas sin restricciones. ... View more

Its quite difficult to view reports in dark lighting. Dark mode would really help ... View more

When building a report with over 9 pages (depends on the page title length) its cumbersome to keep pressing the arrow buttons to navigate to a specific page. Please add an openable window displaying the pages from top to bottom with a scroll bar for easy page selection. ... View more

We have a Lakehouse in MS Fabric. All our reports are on a Fabric Capacity Workspace and some reports use the DirectLake connection so I can see them comming off of the SQL Analytics Enpoint for Lakehouse in Lineage View     I have other models that use the SQL Connection String for the SQL Analytics Enpoint for Lakehouse, one uses a SQL query to only retrieve and import specific data and the other imports all data. The issue is, it is very confusing in the Lineage view, because technically, I am connecting to the data in the SQL Analytics Enpoint for Lakehouse but in the view, it just shows me connecting to SQL, there is no line linking the two in the view making the lineage somewhat confusing     I would expect to see a line between the two ... View more

Hello,    I was wondering if additional filters could be added. Such as a filter that can sort by year.   I also think it would be good to have an additional filter that can sort out recently canceled and non-renewed policies from in force/active policies, but was not sure if that was possible?    Thank you,    Kat Baker ... View more

In order for a Power Query data source to be refreshable via scheduled or on-demand refresh inside the Power BI service, the Web.Contents base URL has to be hardcoded. For example, the following is not allowed: (URL) => Web.Contents(URL) Only the following is allowed: Web.Contents (You can pass in dynamic headers or query string parameters.) I propose that you enable Power Query inside the Power BI service to retrieve dynamic base URLs. Please add a setting where I can authorize a particular Power Query data source to grab any URL. This scenario already works inside Power BI Desktop or Excel in that Power Query can retrieve dynamic URLs after the user sets the auth for each dynamic base URL.   Thank You. ... View more

Solicito que en la opción "Exportar datos" de Power BI exista un formato de salida en Excel más amigable para todo tipo de usuario. Actualmente, la exportación entrega archivos que no siempre son fáciles de utilizar y requieren limpieza adicional. Propongo que Power BI permita elegir entre dos modos de exportación: - Tabla en CSV (datos crudos, como existe actualmente). - Tabla en Excel (con formato básico, encabezados claros y estructura más legible). Esto beneficiará a usuarios de negocio, reducirá retrabajos y mejorará la experiencia general en el uso de reportes exportados. ... View more

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