Can Scorecard(Goals) be used for custom Power BI visuals?
Hi everyone, I'm evaluating Power BI Scorecards (Metrics) for KPI/KRI tracking. During testing, I noticed that a Scorecard creates an associated semantic model that is visible in Fabric/OneLake. However, the semantic model appears to be DirectQuery-based, and I haven't been able to use it the same way I would a normal semantic model for reporting. My goal is to: Maintain KPI/KRI values in a Scorecard using manual data entry check-ins Build custom Power BI reports using that data Create visuals such as bar charts, pie charts, stacked columns, trend charts, and executive dashboards My questions are: Is the automatically created Scorecard semantic model intended to be used as a source for custom Power BI reports? Can regular check-in be used as a data entry point? Are there DirectQuery or modeling limitations that prevent custom visualization? Has anyone successfully used Scorecard metric data to build custom report visuals outside the Scorecard experience (other than the trend view)? I can see the associated semantic model in Fabric, so I'm trying to understand whether I'm missing a configuration step or if the model is only intended to support the Scorecard itself. Thanks in advance!
API equivalent of "Configure Connection > Connect" for Dataflow Gen2?
We're automating Dataflow Gen2 onboarding for unattended refresh using the Fabric REST API. Our service account owns an on-premises gateway connection (OAuth / Organizational account) that reports Online via testConnection. We create or update dataflows with this connection in queryMetadata.json — service account is the item owner and connection owner. Refreshes fail with "Credentials are required" until we manually open the dataflow in the portal and click Configure Connection > Connect. After that single click, refreshes work indefinitely. Is there any API or programmatic method that replicates what "Connect" does? We cannot use manual interaction per dataflow, and cannot change to Basic/Windows credentials and must use OAUTH2
Dataflow Gen2 Issue
When trying the new "Dataflow Gen2", an error of "There was a problem refreshing the dataflow. Please try again later. (Request ID: aa7e41ba-d6a9-47df-8d67-e5a3c98146b2)." persists. To test, I have an exact copy of the same Dataflow but non "Gen2". This one is running without issue, suggesting that the issue is specific to the Gen2. The source is a SQL Server through a Gateway. The Gateway is up to date (May 2023)
Optimizing the CSV files load in Warehouse from Lakehouse through Dataflows
Join the Indore Data & BI Community (IDBC) for another insightful online session of DATA CONNECT Series where we explore how to Optimizing the CSV files load in Warehouse from Lakehouse through Dataflows. Date: 22nd March 2025 Venue: Online Speaker: Inturi Suparna Babu (Microsoft Super User) Host: Anmol Malviya (Microsoft Super User) Don’t miss this opportunity to Learn, Collaborate & Innovate with the Microsoft Fabric Community! Join WhatsApp group for more updates: https://chat.whatsapp.com/HL6aOLHMqAGJm1JqpzhkJw ________________________________________________________________________________ Microsoft Teams meeting Join on your computer, mobile app or room device Click here to join the meeting Meeting ID: 934 137 410 019 7 Passcode: YB2N59 Download Teams | Join on the web Learn More | Meeting options ________________________________________________________________________________Construyendo una Solución End-to-End con Microsoft Fabric y Power BI
En esta sesión práctica y estratégica, exploraremos cómo construir una solución completa de análisis de datos utilizando Microsoft Fabric y Power BI, cubriendo todas las etapas clave del proceso: desde la ingesta de datos crudos hasta la entrega de insights accionables al negocio. Veremos cómo aprovechar las capacidades unificadas de Microsoft Fabric —incluyendo Data Factory, Lakehouse, Notebooks, Dataflows Gen2 y Semantic Models— para centralizar, transformar y modelar datos de distintas fuentes. Luego, integraremos estos modelos con Power BI para crear visualizaciones dinámicas que faciliten la toma de decisiones basada en datos.Power Automate export Paginated Reports PDF are blank
Hi Team, Below is my Power Automate flow - Flow Overview Purpose: Export multiple Power BI paginated reports (RDL) to PDF dynamically, based on a CSV file, and email them as attachments in a single email. Trigger: Manually trigger a flow, with a File input (CSV upload containing DealName,ReportID per row) Flow steps: Get CSV Text — Compose action: decodeBase64(triggerBody()['file']['contentBytes']) to convert the uploaded CSV into readable text Split Rows — Compose action: splits the CSV text into an array of row-strings (one per line) Initialize variable — PDFAttachments, type Array, initial value [] Apply to each — loops through each row in the CSV Condition — skips the header row and any empty trailing row Split Columns — Compose action: split(item(), ',') to break each row into [DealName, ReportID] Export To File for Paginated Reports — calls the Power BI paginated report export API: Workspace: fixed/static (single workspace for all reports) Report: dynamic — set via custom value to outputs('Split_Columns')[1] (the ReportID from CSV) Format: PDF Parameters: only DealName is passed, set to outputs('Split_Columns')[0] Append to array variable — builds a JSON object per PDF (Name, ContentBytes, ContentType) and appends to PDFAttachments Send email (V2) — after the loop, sends one email with all PDFs in PDFAttachments attached The Problem The flow runs successfully end-to-end (all green checkmarks), and PDFs are generated and emailed correctly.However, for reports, the resulting PDF opens fine but every page is completely blank — no report content renders at all, even though the same report + parameter value works perfectly when tested manually in Power BI Report Builder.Also checked the raw outputs of DealName and ReportID are passing correctly in loop but PDF are blank what can be issue.Can anyone please suggest me the solution how this can be resolved? Thanks, Chetan
Dataflow Gen 1 refresh history missing
Hi community, I understand there was a service outage for Gen 1 dataflows over the weekend that prevented Gen 1 dataflows from refreshing. However, upon inspecting the refresh history of my dataflows, I've realised all the Gen 1 Dataflows across my org's tenant have a week of refreshes missing (29 July - 6 August). These are typically dataflows with a single daily refresh schedule. However, we did not get any refresh failure notifications to our nominated inboxes. Has anyone else had similar issues? We aren't sure if a) the refreshes did go through and the history has been wiped, or b) the refreshes didn't go through at all Thanks for any helpDataflow Gen2 - failing to load into the lakehouse
Hello. I have a dataflow gen2, fetching data from an azure data factory environment and loading them into a Fabric Lakehouse. It has been working flawlessfly for the last 3 months, but since two weeks, on some of the tables, I get this error: "There was a problem refreshing the dataflow: "Something went wrong, please try again later. If the error persists, please contact support.". Error code: EntityUserFailure. (Request ID: 6d111afc-11ee-459f-9e31-db4d08c32c44)." "XXX - ABC Entity Management_WriteToDataDestination: There was a problem refreshing the dataflow: "Couldn't refresh the entity because of an issue with the mashup document MashupException.Error: Error in creating lakehouse table in a version, InnerException: Tables can only contain uppercase or lowercase letters, numbers or the underscore character., Underlying error: Tables can only contain uppercase or lowercase letters, numbers or the underscore character. Details: Reason = Expression.Error;ErrorCode = Lakehouse036;Message = Tables can only contain uppercase or lowercase letters, numbers or the underscore character.;Message.Format = Tables can only contain uppercase or lowercase letters, numbers or the underscore character.;ErrorCode = Lakehouse019;InnerErrorCode = Lakehouse021,Lakehouse019;Microsoft.Data.Mashup.Error.Context = User GatewayObjectId: 1ee1c1a1-a11v-32bt-a19b-5ff6d874f432". Error code: 104100. (Request ID: 66d111afc-11ee-459f-9e31-db4d08c32c44)." The weird part is that there is no consistency between which tables go to error and which ones proceed to being loaded. Sometimes it works sometimes it does not. Also, there are no issue with the naming, as all the columns are respecting the requirements laid out from the error. And above all, it was working flawlessly until few weeks ago and nothing a
