Fabric F64 Paginated Report Capacity: Workarounds Besides Increasing SKU?
Hi everyone, I am looking for guidance on managing high-concurrency usage of a Power BI paginated report in a Microsoft Fabric F64 capacity. The report serves a large K–12 environment with tens of thousands of students across 80+ schools. Users can select a teacher and one or more of that teacher’s courses to generate student-profile-style output. They can also run the report by school and grade level. Under normal use, the report performs acceptably. The issue occurs during short, predictable high-demand windows—such as conference periods—when many schools access and export the paginated report at roughly the same time. During those periods, the workspace/capacity can reach its maximum capacity, affecting workspace and report availability and performance. Before pursuing a larger SKU, I would appreciate guidance on possible alternatives or design patterns. In particular: Are there recommended ways to manage a high number of simultaneous paginated-report executions on an F64 capacity? Are there report-design or dataset/query optimizations that tend to make the largest difference for this type of parameter-driven, teacher/course-level report? Would using subscriptions, pre-generated exports, or another distribution approach help reduce interactive demand during peak windows? Is autoscale/burst capacity a practical option for short, predictable usage spikes? Are there capacity metrics or thresholds you would recommend monitoring to determine whether the bottleneck is report rendering, dataset/query execution, or overall capacity? Thank you for any recommendations or examples of similar deployments.
Html error 'spam' style
For a few weeks now whenever i try and publish anything i get that error message, even if i just have nothing but text and have attached an example file. what can i do , this only started after last update, before that all worked fine. is it just a case of go back to forum? i would show a screen shot but that would probably make this invalid as well. Richard.
Problem with Inspiration, Power BI galleries?
I can't see any Power BI reports in Power BI galleries For example, when I click on Fire! Leicestershire Fire and Rescue Service incident report | Microsoft Fabric Community I see the following Same for all in Contests Gallery | Microsoft Fabric Community Themes Gallery | Microsoft Fabric Community
Help! explain this measure and why it isn't working consistently!!
I have a report that someone else made and they are not seeing some data show in the visuals that they would expect to see. After investigating I found out that the measures are behaving strangely. Basically there are 3 measures. One determines if there are any items on a SalesOrder that have a synthesisDepartment of "LEU Main - Tubes" : HasLEUMainTubes = VAR CurrentSalesOrder = MAX('vwOperationsBacklog'[SalesOrder]) RETURN CALCULATE ( COUNTROWS ( 'vwOperationsBacklog' ), 'vwOperationsBacklog'[SalesOrder] = CurrentSalesOrder, 'vwOperationsBacklog'[SynthesisDepartment] = "LEU Main - Tubes" ) One determines if there are any items on a SalesOrder that have a synthesisDepartment of "LEU Platinum" : HasLEUPlatinum = VAR CurrentSalesOrder = MAX('vwOperationsBacklog'[SalesOrder]) RETURN CALCULATE ( COUNTROWS ( 'vwOperationsBacklog' ), 'vwOperationsBacklog'[SalesOrder] = CurrentSalesOrder, 'vwOperationsBacklog'[SynthesisDepartment] = "LEU Platinum" ) And the third measure determines if the SalesOrder has items from both departments: HasBothLEUMainTubesAndPlatinum =IF ( [HasLEUMainTubes] > 0 && [HasLEUPlatinum] > 0, 1, 0) The visual is a table that displays a list of SalesOrders that have both Main and Platinum items. However, the users only want to see $ values and specific products that are from Main and have applied a visual level filter of Synthesis Department = "LEU Main - Tubes". Here is the issue: In most cases, this works out fine. Example order 9558544 which has 8 items in each of the two departments shows up in my main visual with only $ associated to the Main department. BUT example order 21583399 does NOT show up in the table even though it has 2 Platinum items and 3 Main items. I created a quick look at these 2 orders and the results of the 3 measures below (separated by Synth Dept) As soon as I apply a visual level filter to that same table (setting Dept = Leu Main - Tubes), this is the result: WHY DOES ONE ORDER WORK DIFFERENTLY FROM THE OTHER????? I also know I could probably come up with a better way of doing this (I did not develop these measures, a user did) but I ultimately want to know why it functions like this.
Displaying a Row as Fixed, when it's value needs to be manipilated
*I have trouble converting the data type of Column Amount in Source ABC to Decial/Numbers for this tutorial(help needed), see data source:https://drive.google.com/file/d/1VZJv8sPPYPcLiRKyO1fkEqbcsX-dz10P/view?usp=sharing . PBIX:https://drive.google.com/file/d/1wfjbLI7nBLQU5-Qs5rGHOL2XP4uc0UR9/view?usp=sharing I am trying to include rows in a Dax calculation from a mapping table(Pivot) to a fact table(ABC). The DAX is going to look at specific rows and bring those forward. The big issue is some rows are not present in the Fact table. I also need those rows to be displayed but their values to be manipulated. An example is row "Interco capital returned", which is not in the Fact Table(ABC), it should display a fixed value of "678" TotalAmountForSelectedItems5 = CALCULATE( SUM('ABC'[Amount]), // Corrected Column Reference 'ABC'[Roll_Up_Function] IN { "Cash flow from ops - management", "Cash flow from trading", "Depreciation and amortisation", "IPEP expense", "Disposals & impairment of fixed assets", "Profit on disposal of pooling equipment", "Scrapped pooling equipment", "Impairment or valuation adjustment of pooling equipment", "Disposals or valuation adjustments of other fixed assets", "Other cash flow from trading adjustments", "Share-based payments expense", "Working capital mvts incl. provisions", "Working capital mvts excl. provisions", "Debtor movements", "Creditor movements", "Inventory movements", "Prepayment movements", "Provision movements", "Change in capex creditors", "Change in loss compensation balances", "Interco interest and guarantee fees", "Interco cash flows", "Interco royalties", "Statutory reallocations", "Internal restructuring", "Interco dividends Total", "Change in interco balances", "Change in interco recharge clearing", "FX on interco debt", "Interco capital returned" } ) amitchandak jpessoa8 lbendlinSPC Graph virtually blank when migrated into OnPremises (Remote Server) PBIX
Good Afternoon, I am building a new version of a Dashboard in OnPremises Remote Server (PBIX File). It had originally been developed in the previous Desktop version. I am using the following SPC (Dev) Chart: Id: PBISPC_DEV Version: 1.4.4.20 In the previous Desktop version, a graph appears as this: But when I copy the exact graph into the new PBIX File (OnPremises Remote Server), it comes up virtually as a blank (in spite of all Tables and Measures being migrated over): Kindly Advise.Migrating Pages from one PBIX file (Desktop) to another (Onpremises Remote Server)
Good Morning, I am building a new version of a dashboard (into Onpremises Remote Server Version: 2.150.1926.0 64-bit (January 2026) from a version previously created in Desktop 2.145.1105.0 64-bit (July 2025)). There are over 30 tables and over 15 pages in the existing dashboard. I am moving across the Tables (to the new PBIX file) and creating the relationships between them manually. I considered it better to make the effort to manually join the tables in Model View - rather than autodetect - so that I know exactly what Table is linked with which Table (and upon what fields). Or would autodetect have been preferable ? Now the main issue is copying the 15-ish pages (with the plethora of visuals contained within these !) to the new PBIX file, especially that several of them contain Overlays (with buttons allowing different views of the data to be presented). So such pages may have many Visuals contained which are hidden - dependant on which view button has been invoked. For example: Kindly advise if there is an efficient way to move across the pages. Regards
