Power BI model suddenly failing due to circular dependency issue
Hi team , My Power BI model was working fine until recently, but it has now started failing with a circular dependency error. I tried modifying the formula it was pointing to, but this triggered issues across many other calculated fields that depend on it, making it very difficult to update all of them without causing data discrepancies. Is there a way to resolve this circular dependency issue without modifying the existing DAX logic? Any guidance would be appreciated.
Workaround for OLS related Limitations
Hello Everyone, When we are dealing with OLS in our semantic model. We came up limitations, i would like to know if any workarounds. Before OLS implementation our Model Structure: Role A can see Column A. Role B can see both Column A and Column B. We use Column A and Column B in a same metrics & toggle between both based on the Logged in Roles. We used a Metrics to toggle between Column A and Column B. (Reason is both column meant for alike data display, eg, Profit and Profit_withMargin) We have 700 metrics. Now Challenge during OLS implementation: If we apply OLS in our model, When Role A logsin our metrics break because we Column B in the metric is been filtered by OLS feature. To overcome this we have two solution. One to create metrics seperately for each role. This will be heavy maintanence activity if any new role got added in future. Second to depivot the table in ETL. (Ex: Keep both Profit and Profit_withMargin in same column) and apply RLS. This will increase datasize alot. Chances of getting performance and load issue are high) Any one face similar issue and have anothe quick fix workaround? Please let me know. Thanks in Advance.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 super
Line chart
Hello All, I have a line chart which I want to create as below, in PBI: I can create almost everything but not able to create the deciosn pointers, which are hightlited as the small thick mark on each lines, not sure how can I get that. Below is the table which I want to use. country Forecast Accuracy - 3 month ahead Forecast Accuracy - 2 month ahead Forecast Accuracy - 1 month ahead Decision Point Spain 84 % 83 % 99 % 56 Brazil 96 % 95 % 97 % 50 Italy 79 % 71 % 80 % 56 India 81 % 84 % 82 % 15 Mexico 96 % 98 % 96 % 40 China 95 % 97 % 96 % 5 Germany 93 % 93 % 92 % 56 United States 99 % 98 % 100 % 35 United Kingdom 71 % 78 % 89 % 56
