tutorial requests
2520 TopicsSemantic model refresh failure notification across tenant
Hi Currently, when a semantic model scheduled refresh fails, it sends an email notification to the user/ users mentioned in the refresh settings of that model. We have more than 100 data models. Is there a way to notify certain important users via email, whenever any data model fails across the tenant? We do not want the hassle of changing the individual refresh settings of each semantic model. I've heard that this is not possible within PowerBI service and that we have to use Power Automate. Any help is appreciated.Solved3.1KViews1like7CommentsHow to get the internal Page Name and Visual Name for Power Automate
Hi everyone, I am trying to automate a daily Power BI report email using Power Automate. My requirement is: Power BI Report ↓ Power Automate ↓ Export a specific Power BI visual as PNG ↓ Embed the image in an HTML email ↓ Send the email daily I already have an existing Power Automate flow that sends an HTML table successfully. Now I also want to include a Power BI chart below the table in the same email. I am using the Power BI action: "Export To File for Power BI Reports" I have selected: - Workspace - Report - Export Format = PNG The action provides the following fields under Pages: - Pagename - Visualname - Bookmark Name - Bookmark State The Power BI report has a page called "X" and the visual I want to export is called "Y". The problem is that I don't know the INTERNAL page name and INTERNAL visual name required by the Power Automate export action. My Power BI Service URL follows this format: https://app.powerbi.com/groups/<workspace-id>/reports/<report-id>/<some-id>?experience=power-bi Unlike some examples I have seen, the URL does not contain something like: ReportSection123abc I understand that the Power BI API uses an internal page name that is different from the visible page name. My questions are: 1. How can I retrieve the internal page name for page "X" in the current Power BI Service experience? 2. How can I retrieve the internal visualName for visual "Y"? 3. Is there a recommended way to get these values without manually inspecting browser/developer tools? 4. Can I use the Power BI REST API / Get Pages API to retrieve the internal page name and then use that value in Power Automate? 5. Is there a Power BI/Power Automate connector or API that can retrieve the visual names using getVisuals or another method? Any guidance would be greatly appreciated. Thanks!Solved83Views0likes6CommentsConnecting to a semantic Model issue
Hello, We created a Snowflake mirrored database in Microsoft Fabric. User A then created a semantic model connected to this mirrored database (OneLake). We have an older semantic model, and I migrated all the measures from it to the new semantic model using TMDL Apply. However, when I tried to connect to User A's semantic model from Power BI Desktop to create reports and visuals, I received the following error: Both User A and I are Workspace Administrators. To troubleshoot, I created my own semantic model on the same mirrored database, migrated the same measures using TMDL Apply, and then connected to it from Power BI Desktop. In this case, the connection worked successfully without any issues. My question is: Why am I unable to connect to the semantic model created by User A, even though we have the same workspace permissions? What could explain the difference in behavior between User A's semantic model and the one I created, given that both are in the same workspace, use the same mirrored database, and have the same measures migrated via TMDL? Any insights or recommendations would be greatly appreciated.Solved188Views0likes5CommentsValidation of my understanding of Fabric Semantic Models, Power BI Desktop, and Workspace Scenarios.
Validation of Microsoft Fabric Semantic Model Architecture, Connection Modes, and Power BI Desktop Behavior Hi everyone, I've been exploring different Microsoft Fabric and Power BI integration scenarios and would like to validate my understanding. I'd also appreciate clarification on a few concepts related to Semantic Models, connection modes, and Power BI Desktop. 1. End-to-End Fabric Architecture Data Sources ↓ Fabric Lakehouse / Warehouse ↓ Centralized Semantic Model ↓ Power BI Reports / Paginated Reports My understanding is: Data is ingested into Fabric Lakehouse or Warehouse. A centralized Semantic Model is created on top of the data. Multiple reports can consume the same Semantic Model. This is the recommended enterprise architecture for governance, scalability, and reusable business logic. Is this correct? 2. Fabric Semantic Model → Power BI Desktop Fabric Semantic Model ↓ Power BI Desktop ↓ Report My understanding is: Power BI Desktop connects to the published Semantic Model using a Live Connection. Reports can be developed in Power BI Desktop. The Semantic Model itself cannot be modified because it is centrally managed in Fabric. However, whenever I connect to a Fabric Semantic Model from Power BI Desktop, Desktop opens in Semantic Model editing mode, and I don't see the Report View. My questions are: Is this expected behavior? Why is Report View not available? Is there a way to create reports directly from the same Power BI Desktop session after connecting to a Fabric Semantic Model, or is this by design? What is the recommended workflow for report developers in this scenario? 3. Power BI Pro Workspace and Fabric My understanding is: A standard Power BI Pro workspace cannot host Fabric artifacts such as Lakehouses, Warehouses, Notebooks, or Pipelines because they require Fabric capacity. However, a Pro workspace can consume an existing Semantic Model published from a Fabric workspace (subject to permissions and licensing). Reports can then be created using that Semantic Model. Is this correct? 4. Connecting Power BI Desktop to a Fabric Warehouse I believe there are two approaches. Approach 1 – Semantic Model Development Fabric Warehouse Tables ↓ Semantic Model ↓ Power BI Desktop Used for Semantic Model development. Opens in Semantic Model editing mode. Report View is not available. Approach 2 – Direct Connection Fabric Warehouse Tables / SQL Objects (Tables, Views, etc.) ↓ Power BI Desktop ↓ Semantic Model ↓ Report Connect directly to the Fabric Warehouse. Use Warehouse tables or SQL objects such as views. Power BI Desktop provides the normal report authoring experience. Semantic Model and reports are developed together. Is this understanding correct? 5. Connection Modes within a Fabric Semantic Model I'm also trying to understand how the following storage/connection modes work in Fabric Semantic Models. Import DirectQuery Direct Lake My questions are: Can all three connection modes be used when creating a Semantic Model in Fabric? What are the recommended scenarios for each mode? Are there any limitations depending on whether the Semantic Model is built from a Lakehouse or a Warehouse? Can these modes be mixed within a single Semantic Model? 6. Refresh Behavior and Data Pipeline I'd also like to understand how Semantic Model refresh works in a complete Microsoft Fabric solution. Assuming data is loaded into a Lakehouse or Warehouse through any Fabric ingestion mechanism, such as: Dataflow Gen2 Notebooks Pipelines Mirroring Shortcuts Other supported Fabric ingestion methods My understanding is that all of these eventually populate the Lakehouse or Warehouse, which is then consumed by the Semantic Model. My questions are: Is this understanding correct? Does the Semantic Model refresh behavior remain the same regardless of whether the data was loaded using Dataflow Gen2, Notebooks, Pipelines, or any other Fabric ingestion process? How does Semantic Model refresh work for each storage mode: Import DirectQuery Direct Lake Is a scheduled Semantic Model refresh always required, or does it depend on the storage mode? For Direct Lake, when new data is written into the Lakehouse or Warehouse, does the Semantic Model automatically reflect those changes, or is some form of model refresh still required? Are there any best practices for orchestrating data refresh and Semantic Model refresh within Microsoft Fabric? 7. Cross-Workspace Scenarios Is my understanding correct? Fabric Workspace Semantic Model → Fabric Report → Supported Fabric Workspace Semantic Model → Power BI Desktop Report (Live Connection) → Supported Power BI Workspace Semantic Model → Fabric Report → Supported Power BI Workspace Semantic Model → Power BI Report → Supported 8. Semantic Model Terminology One area I'm still trying to clarify. Is there technically any difference between a Fabric Semantic Model and a Power BI Semantic Model, or are they actually the same Semantic Model artifact, with the only difference being where they are created or hosted? I'd appreciate any corrections or clarifications. My goal is to build a solid conceptual understanding of Microsoft Fabric architecture, Semantic Models, and the recommended enterprise development workflow. Thank you!Solved148Views0likes4CommentsUnable to create FUAM connection - DMTS_OAuthFailedToGetResourceIdError (Status Code : 400)
Hi All, Am trying to deploy FUAM (Fabric Unified Admin Monitoring) in our fabric environment. The notebook for the deployment when ran should have created the two connections but it did not. I tried creating them manually but running into an error message when trying to create the two necessary connections for it to work. As per documentation I have setup the SPN with the proper tennant level setting as well. Service Principals can use Fabric APIs Service Principals can access read-only admin APIs What am I doing wrong? Did I miss a step? Thanks in advance. NimeshSolved214Views0likes5CommentsPower BI Service Refresh Error: "We cannot convert the value '[Table]' to type Table", Desktop works
Hi everyone, I'm running into a Power BI Service refresh issue that I can't seem to solve. The Error The dataset refreshes successfully in Power BI Desktop, but fails in Power BI Service with: Expression.Error: We cannot convert the value "[Table]" to type Table. Details: Reason = Expression.Error ErrorCode = 10277 Value = [Table] The frustrating part is that Desktop works perfectly, so this appears to be a Service-only evaluation issue. My Query Structure I have a query that: Loads a custom data collection table. Filters active parameters. Joins to a parameter mapping table. Groups source records by parameter value. Uses a custom function (fnExpandMappedParameter) to dynamically expand parameter data. Combines all returned tables into a single table. A simplified version: Source = base_table_custom_data_collection, FilteredParams = Table.SelectRows( dim_parameters_tablenames, each [Parameter Value] <> null ), JoinMapping = Table.NestedJoin( FilteredParams, {"Parameter Table Name"}, dim_newpara_w_tables, {"Parameter Table Name"}, "Mapping", JoinKind.LeftOuter ), GroupedSource = Table.Group( Source, {"Item"}, {{"Data", each _, type table}} ), Joined = Table.NestedJoin( JoinMapping, {"Parameter Value"}, GroupedSource, {"Item"}, "Matched", JoinKind.LeftOuter ), AddTables = Table.AddColumn( Joined, "Result", each let tbl = [Matched], mapping = [Mapping], param = [Parameter Value] in if tbl = null or Table.IsEmpty(tbl) then null else fnExpandMappedParameter( tbl{0}[Data], param, mapping ) ), Combined = Table.Combine(List.RemoveNulls(AddTables[Result])) What I've Already Tried 1. Table.Buffer() I buffered both source and parameter tables, no change. 2. Verify Nested Tables I checked the columns involved, both appear as nested tables in Desktop. No obvious issues appeared in preview. 3. Expand Mapping Earlier I tried expanding the Mapping column, however, downstream logic expects: mapping = [Mapping], which no longer exists after expansion. This didn't solve the refresh issue and likely breaks the original function design. 4. Considered Moving Logic to SQL I considered moving the transformation to SQL Views or Stored Procedures. However, the solution depends on multiple parameter tables, dynamic mappings, custom functions and dynamic column generation. So it doesn't feel like a practical SQL rewrite without substantial redevelopment. I'm wondering if Power BI Service is evaluating one of the nested table objects differently than Desktop. Perhaps somewhere a nested table is being interpreted as the text "[Table]" rather than an actual table object. The part I'm most suspicious of is the below, since this is where nested tables are being passed into a custom function: fnExpandMappedParameter( tbl{0}[Data], param, mapping ) Has anyone encountered a Desktop vs Service issue where a nested table becomes the text value "[Table]" during refresh? Is there a better architectural approach for handling dynamic parameter expansion like this that avoids nested table evaluation issues? Are there known limitations with some of the syntaxes used, that behave differently between Desktop and Service? Any suggestions would be greatly appreciated. I've spent quite a bit of time troubleshooting this and have reached the point where Desktop works consistently but Service continues to fail with the same error. Thanks!Solved212Views2likes6CommentsAssign Power BI license to Azure Managed Identities
Hello There, We would like to automate some tasks with Power BI PowerShell modules' Cmdlets. We would like to use Azure Automate runbooks. Some task require that a Power BI license be assigned to the user, who execute this task. Can we assign Power BI license to Managed Identities and how we can use Connect-PowerBIServiceAccount cmdlets with Managed Identities? Thank you for your suggestions. Best regards, CleanDesk266Views0likes6CommentsPBI Service fail to refresh but works fine in Desktop
I have a report that has been working for months. Automatic refresh is all set up and running previously. I'm using this as my setup. Database: SQL Express Gateway: Standard On-Premises Data Gateway But suddenly starting from last month, the report suddenly failing to be refreshed after published. I did added a few dashboard in but it touches no previous table that were already in either in the query or the relationship. Previously, I did the same thing (add new dashboard or editing the already created ones) but there were no such error happening when i try to refresh it in Power BI Services. In Power BI Desktop, I can refresh it just fine with no errors. At this point, I dont know what else to do as I've troubleshoot and tried so many things (downgrading and upgrading the gateway, the privacy setting, DAX, tables, connections, etc.). Ive also tried to just create new gateway and connection when reinstalling the gateway but nothing works. I really can't figure out how to get past this or find what the real error is. Any ideas is very much appreciated. This is the error I get when I try to refresh on PBI service.Solved371Views0likes8CommentsIntegration with BOX for picture storage
So, I am being told that i cannot store pictures in BOX, and hyperlink them to power BI I know picture sharing isnt a typical thing in Power BI, but the needs of our shop require oth power BI and picture sharing in the same instance. Also, i am told storing images on a network folder wont work as well. base64 images at 24mb are too small, we need to share higher def images on larger screens than that.Solved193Views0likes6Comments