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)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 help
Understanding Power BI B2B Licensing and Embedded Scenarios
Understanding Power BI B2B Licensing and Embedded Scenarios I'm trying to understand how Power BI licensing, Microsoft Entra B2B, and Power BI Embedded work together. I'd appreciate clarification on the following scenarios. Scenario Tenant A owns the Microsoft Entra tenant, Power BI tenant, workspace, semantic model, reports, dashboards, and apps. [email protected] is an external user. Question 1 – B2B Guest + Pro Workspace Assume [email protected] is invited as a B2B guest into Tenant A. The workspace is a Power BI Pro workspace (not Premium Capacity or Fabric Capacity). What are the exact checks Power BI performs before allowing access? Are the checks performed in this order? User authentication B2B guest validation Tenant settings Power BI license validation Workspace/App permissions Semantic model permissions RLS Is this the complete authorization flow, or are there additional checks? Question 2 – Cross-Tenant Licensing If the external user has a Power BI Pro license assigned in their home tenant (Tenant B): Can that license be used to access reports hosted in Tenant A? If yes, how does Microsoft validate the license across tenants? Does the guest require a Pro license assigned in Tenant A, or is the home tenant license sufficient? Question 3 – User Owns Data vs App Owns Data I'm trying to understand the architectural difference. User Owns Data Who authenticates to Power BI? Does Power BI evaluate the end user's identity? Is a Pro/PPU license required? What happens if the user has no Power BI license? App Owns Data Who authenticates to Power BI? Does Power BI evaluate the end user's identity or only the application/service principal? Why is Embedded Capacity required? Why doesn't the end user need a Pro license? Question 4 – Embedded with Existing B2B Users Suppose the external user is already a B2B guest in Tenant A. Instead of accessing reports through Power BI Service, they access them through a secure web application using Power BI Embedded. Is this a supported architecture? Should this use User Owns Data or App Owns Data? Which approach is recommended and why? Question 5 – Recommended Architecture For each of the following scenarios, what is the recommended architecture and licensing model? Internal employees External partners (B2B guests) Customers using a secure web portal Public-facing dashboards When should I choose: Power BI Service B2B Guest Access Power BI Embedded (User Owns Data) Power BI Embedded (App Owns Data) Publish to Web I'm looking for the recommended architecture along with the licensing requirements for each scenario. amitchandak Ashish_Mathur superPower BI Pro Gen 1 Dataflow Refresh Limit: Per Dataflow or Workspace-Wide?
I'm trying to understand the dataflow refresh limit on a Power BI Pro workspace, and I'm getting conflicting information from the documentation. **Our scenario:** - Power BI Pro license (shared capacity) - Multiple analysts in one workspace who build semantic models - We're considering using shared dataflows to reduce source system query load - Each dataflow would need to refresh 5+ times per day - We'd have approximately 5 dataflows in the workspace **What the documentation says:** I found this in the Microsoft Learn docs: "A Power BI Pro license has a dataflows refresh limit of 8 refreshes per day." But I need clarification: **Is this limit per dataflow, or is it 8 refreshes total across all dataflows in the workspace?** For example: - Scenario A: Each dataflow can refresh up to 8 times per day independently (so 5 dataflows × 8 refreshes = 40 total) - Scenario B: Only 8 total refreshes allowed per workspace across all dataflows combined (so 5 dataflows × 5 refreshes = 25, which exceeds the limit) We're trying to determine if dataflows are feasible for our use case. If it's Scenario B, we need a different approach (like materialized views at the database layer instead).
