data hub
283 TopicsPaginated Report Matrix with Dynamic Columns Causing PDF Export Issues
Hi everyone, I'm working on a Paginated Report (RDL) that contains a matrix. The matrix columns are grouped by Product Type, so the number of columns grows dynamically depending on the data returned. Scenario Rows contain summary data. Columns are grouped by Product Type. The number of Product Types varies and can become quite large. As more Product Types are returned, the matrix expands horizontally. Issue 1: Managing Page Width in PDF Export When exporting the paginated report to PDF, the dynamically generated columns can exceed the page width. Questions What is the recommended approach for handling matrices with dynamically growing columns when exporting to PDF? Is there a way to automatically scale the matrix to fit the PDF page width? Are there any best practices for: Switching between portrait and landscape layouts? Splitting columns across multiple pages? Using page breaks for column groups? Handling a variable number of dynamic columns? Issue 2: Extra Blank Page Appearing in PDF Export In addition to the width issue, each report page is followed by an extra blank page when exported to PDF. Current Settings Report has a fixed page size. Margins appear to be within normal limits. Matrix width changes dynamically based on Product Type values. Questions Can dynamic matrix width cause additional blank pages during PDF export? What are the common causes of a blank page being generated after every report page? What should I check to identify whether the issue is caused by: Report body width Matrix width Rectangles/containers Page size and margins Hidden objects extending beyond the printable area Expected Outcome I would like the report to: Export to PDF without creating extra blank pages. Handle a varying number of Product Type columns gracefully. Maintain readability even when the matrix expands horizontally. Any guidance, best practices, or examples would be greatly appreciated. Thanks!38Views0likes3CommentsPlan module (used to be powertable), single select columns becomes blank when sorted.
We have used powertable before, and have migrated into the plan module to have our master data, including our Employee table When sorting by ReportingTo the EmployeeName column becomes blank. I have added the configuration of the EmployeeName but its similar to Initials that is not affected Does anyone have any idea of what is going on? Had it affected all single select column the error had been consistant, but EmployeeName and Initials are both using the same jira.user table in its look up.Solved384Views0likes5CommentsFabric Trial Activation Screen Appears but Trial Is Not Available
Hello Microsoft Fabric Community, I am a BCA student from India and I am currently learning Microsoft Fabric for educational purposes. I need access to Fabric features such as Lakehouse, Notebooks, and Data Engineering for hands-on practice. I am facing a confusing issue while trying to activate the Microsoft Fabric trial. My Power BI individual trial is already active and shows 59 days remaining. However, when I click "Start Fabric trial", I get the "Activate your 60-day free Fabric trial capacity" screen. The activation screen shows: - A 60-day free Fabric trial capacity - Trial capacity region: Default – Central India - An "Activate" button However, after proceeding, I receive this message: "Your Power BI trial is active Your free Power BI trial gives you 60-day access to Power BI paid features. A Fabric trial isn't available for your account. See the Microsoft documentation for eligibility requirements." This is confusing because the previous screen allows me to activate a 60-day Fabric trial capacity, but the next message says that a Fabric trial is not available for my account. I have also already confirmed that: - Users can create Fabric items is enabled. - Users can try Microsoft Fabric paid features is enabled. - My Power BI trial is active. - I am using a newly created tenant. - I am trying to use Fabric for learning and educational purposes. I do not have a college-issued student email/Student ID that I can use for verification. Could someone please clarify: 1. Why is the Fabric trial activation screen appearing if my account is not eligible? 2. Is my newly created tenant too new for a Fabric trial? 3. Is there any legitimate way to enable a Fabric trial capacity for this account? 4. If I am not eligible, what is the recommended way for a student to practice Fabric features such as Lakehouse and Notebooks? I would really appreciate any guidance, as I need Fabric hands-on practice for my learning. Thank you.102Views0likes3CommentsDatagateway stuck at "Failed to sign in. Please Verify your credentials and try again."
Im droping this here as i didnt see anywhere where this had been addressed. When trying to signin to the data gateway the app freezes and says "Failed to sign in. Please Verify your credentials and try again." The credentials are good and everything was fine prior to update. I got this after updateing the datagateway. The app freezes up and you have to force close. The work around is that you click signin options prior to entering email select these options and it will redirect you to your browser to login and wont lock up hope this someoneSolved51Views0likes2CommentsSnowflake Mirroring – Error 100089 / AuthenticationError during replication
Hi everyone, I'm experiencing an issue with Microsoft Fabric Mirroring for Snowflake. On the Snowflake side, the COPY INTO command issued by Fabric Mirroring fails with the following error: Error 100089: Failed to access remote file: access denied On the Fabric side, the mirrored database shows AuthenticationError and the status "Running with warnings." Interestingly, some large tables (around 700 million rows) successfully completed the initial replication, while other tables fail with the error above. In addition, currently all tables show the following warning: Could not obtain a connection from the pool within a given timeout ErrorCode: AuthenticationError SequenceNumber: 154 Since some very large tables were replicated successfully, I'm not sure whether this is actually related to Snowflake permissions/authentication, or whether it could be related to the connection pool, temporary staging/remote file access, or Fabric Mirroring itself. Has anyone encountered a similar issue with Snowflake Mirroring? In particular, I would appreciate any guidance on: What could cause Failed to access remote file: access denied for the COPY INTO command generated by Fabric Mirroring? Why would only some tables fail while others successfully complete the initial replication? Could the Could not obtain a connection from the pool within a given timeout warning be related to the Snowflake COPY INTO access-denied error? Are there any logs or additional diagnostics in Fabric that can help identify the root cause? Any suggestions would be greatly appreciated. Thanks!Solved58Views0likes3CommentsUnable to Start Microsoft Fabric Trial – Lakehouse Creation Fails
Hello Microsoft Fabric Team, I am a BCA student from India and I am currently learning Microsoft Fabric for educational purposes. I need access to Fabric features such as Lakehouse, Notebooks, and Data Engineering to complete my learning and hands-on practice. Unfortunately, I am unable to start the Microsoft Fabric trial on my account. My Power BI trial is active (59 days remaining), but whenever I try to create a Lakehouse or click "Start Fabric trial", I receive the following error: "Sorry, we are unable to start trial at this time." I have already verified the following: - My Power BI trial is active. - The tenant setting "Users can try Microsoft Fabric paid features" is enabled. - I am signed in with the correct Microsoft account. - The issue occurs every time I try to create a Lakehouse. Error details: Activity ID: a6e33655-e11b-4ca1-9fdf-322928b6540c Request ID: 2160d856-3b1c-4fa3-80c9-41e043e2efe6 Correlation ID: e741fc43-8faf-9d31-923d-749d5b6eb5d3 Status Code: 200 Cluster: India Central Could you please check whether my account is eligible for the Microsoft Fabric trial? If there is any issue with my account provisioning or eligibility, I would greatly appreciate your assistance in resolving it. As a student, I am using Microsoft Fabric only for learning and practice, and access to the Fabric trial is essential for completing my coursework and hands-on labs. Thank you for your time and support. Kind regards, Mohd ZaidSolved182Views1like9CommentsOn-Prem Data Gateway Silent Error and storage cache
Hello, I'm writing to try and understand an issue we had in office today. Over the weekend we received a semantic model refresh error that said our data gateway went offline. Our first error came at midnight on Saturday. We have most semantic models scheduled for either midnight or 1am. When I got into the office today and noticed that our reports had not been updated since Friday, I found that within Power BI service under workspace connections when I realized that our on on-prem data gateway was offline. When I investigated our SQL server which is where our gateway is installed our C: Drive was using 199gb of 200. The on-premises data gateway service had a status of running. Our SQL data is stored in the 😧 drive and that was healthy, the gateway is installed on the C: Drive. We expanded the drive and restarted the server. This caused a power automate flow, which uses the SQL trigger "When an Item is created (v2)", to execute everything over everything that was added through the weekend. Our C Drive is now at ~150gb of 250 (since we expanded). This is leading me to believe that the On-Premises data gateway lost connection sometime Friday, started caching 2.5 days worth of data, and clogged our C Drive. Is this supposed to happen? Is there a way for us to know if the gateway lost connection without waiting for a semantic model refresh error?Solved174Views1like4CommentsCreation of fabric trial account
I created my tenant account 5 days back and now would like to create a fabric account for practice. The free trail only gives me powerbi trail and not the fabric. I have my exam voucher where exam need to be scheduled by 30th september. I am in urgent need for hand on practice on fabric. Is there any work around this? Kindly help me outSolved130Views0likes6Comments