power bi
44745 TopicsPower Bi Apps
Hi, When creating an app for content distribution can you mix content from different workspaces? Also, I heard about Org Apps which is something I only recently came to know about. I’ve been using just normal apps. Is Org Apps available only in premium licence or can you use in it in pro licence as well? Whats the difference between the two ? Is it ok to continue using normal app? Thank You!!5Views0likes2CommentsData not updating
I've set up a ticket system on SharePoint which feeds into my Power BI. The visuals are not updating, I've done a manual refresh, refreshed the visuals and nothing changes. If anyone can lend any assistance that would be greatly appreciated. I've reestablished the connection and nothing changes.9Views0likes3CommentsMake Slicer Default to Specific Month
I would like to find a way to make my monthly slicer default to the most recent month whenever the report is opened, but also allow users to change the month selected. I’d like to be able to do this with DAX rather than adding a calculated column or additional tables. So far, the closet method I’ve found is this tutorial with the below DAX Master Slicer Defaults in Power BI with DAX Functions | Scenario-based interview questions ‘MainTable’[Month] = IF ( NOT ISFILTERED('YourTable'[Category]), CALCULATE ( SUM('YourTable'[Sales]), 'YourTable'[Category] = "Electronics" ), SUM ( 'YourTable'[Sales] ) ) But I don’t want to Calculate or SUM any information, I just want my slicer to default to the most recent month. Is there a way to modify this DAX for that purpose? I’m open to changing the DAX monthly if it won’t update automatically, but at the very least I’d like to able to set the slicer to a specific month. Thank you22Views0likes3CommentsDirect Query
Hi Folks, Been a while since I touched power bi so I am bit rusty with few of the important concepts. I was looking at the different storage modes like import vs direct query. As far as I recall I know direct query doesn’t give you the data view in power bi desktop so you can’t see your data which is normally the place where you can create a calculated column. Having said that, my thinking tells me you therefore cannot create a calculated column on a table that has direct query. But ChatGPT saying you can create a calculated column on a table that has direct query. Does anyone know if this is true? Thank you!Solved16Views0likes2CommentsTotals and sub-totals in table/matrix visualization or custom visualization
Hi, I am trying to create a report in a Table visualization, or custom visualization, where there are primary and secondary levels which need to be counted, then I need to add a column for the end of the month, group the rows by facility name, then pivot across dates. I can do this easily in Excel, but I want to migrate that process to Power BI if at all possible. The raw data is attached. If I cannot do this in Power BI natively, is there a custom table/matrix visualization I can use to accomplish this? Bruce13Views0likes2CommentsShare your thoughts on the Gantt chart visual (preview)
Have you used the new Gantt chart visual (preview)? We’d love to hear from you! What is the Gantt chart visual? The Gantt chart is a new Power BI visual currently in preview. It provides a way to visualize project schedules, tasks, milestones, timelines, and progress directly in your Power BI reports. How can I learn more about the Gantt chart? Check out the documentation here: https://learn.microsoft.com/power-bi/visuals/power-bi-visualization-gantt We’re especially interested in hearing about how you’re using the visual, what’s working well, what could be improved, and what capabilities you’d like to see next. Some guidelines to keep in mind: Be specific: Clearly describe what worked well or what didn’t, providing concrete examples where possible. Screenshots would be great, but please use fake data or hide your data values. Stay respectful and objective: Focus on the product or feature, not the people behind it. Offer suggestions: If pointing out an issue, recommend potential improvements or alternatives. This helps us understand what we can do differently. Be concise: Keep your comments focused and to the point to ensure your feedback is actionable. Looking forward to hearing from you! Zoe Douglas, one of the Power BI Product Managers252Views4likes11CommentsAnnouncing the retirement of R and Python visuals in Power BI
The built-in R and Python visuals in Power BI will retire in May 2027. What changes This retirement applies only to R and Python visuals in interactive Power BI reports. Python scripts used in Power Query to populate tables are not affected. Power BI service: At retirement, all R and Python visuals will stop working in published reports, including those published before retirement. R-powered custom visuals: Custom visuals that use R will also no longer work at retirement. Older versions of Power BI Desktop: These visuals will continue to work locally using R and Python installed on your machine. Future versions of Power BI Desktop: After retirement, R and Python visuals will be removed, so you won't be able to add them to reports. What you need to do No migration within your report will recreate your exact R or Python visual. You must replace it with a different visualization before retirement. Start reviewing your reports for R and Python visuals and communicate within your organization that reports using them will be impacted. Preserve their scripts and dependencies. If you use Power BI project (PBIP) format and Git-integrated workspaces, search your report definitions in source control to find these visuals across multiple reports. Look for the visualType values pythonVisual for Python visuals and scriptVisual for R visuals. Keep the visualization in your report. Rebuild it with a built-in Power BI visual or an existing custom visual. AI coding tools can also help you create a visual with the Power BI custom visuals software development kit (SDK). The Power BI roadmap includes planned HTML and Vega core visuals for more flexible report visualizations. Check the roadmap for planned availability. Recreate the analysis or visualization outside the report. Explore these alternatives: Fabric notebooks: Recreate the analysis and visualization in a notebook. Scripts may need changes for supported languages, libraries, and data access. Fabric Apps: Explore this option for visualizations that can't be recreated in a Power BI report. Both Fabric notebooks and Fabric Apps can be added to Organizational Apps to share them with your audience. Next steps Test your replacement and let report consumers know what's changing before retirement. If you view an affected report but don't own it, contact the report owner. Learn more in the R visuals documentation and Python visuals documentation. Share feedback on this retirement in the comments.247Views0likes0CommentsMissing Product Key 50 in Customer Profitability Sample
Hi, I've been working with the Customer Profitability Sample dataset in Power BI and noticed a discrepancy between the Fact and Product tables. The Fact table contains records with Product Key = 50, but there is no corresponding entry in the Product table. I also checked the original Customer Profitability Sample-no-PV.xlsx file in Excel Power Pivot and found the same discrepancy. Could someone confirm whether Product Key 50 was intentionally left out of the Product table, or whether this is an error in the sample data? Thanks in advance Best regards, Dagmara Nowak-TrzepałkaSolved33Views0likes4CommentsPer-visual Data Freshness Badge with configurable staleness alerts
Problem: Report consumers can’t tell whether the data behind a specific visual is current. Page-level “last refreshed” workarounds ignore that different tables refresh on different schedules, which leads to decisions based on stale numbers. Proposed solution: Add a “Data freshness” option under the Format pane of every visual. Show a small badge with the last successful refresh time of the tables the visual uses. Let authors set a staleness threshold (for example 6h or 24h, with Date). The badge turns amber or red when it is exceeded. Support a tooltip with per-table refresh times and the data source. Benefits: Greater trust in reports, fewer “is this data old?” support questions, and better governance with no custom DAX or Power Query workaround. Example: A sales visual reads from a daily-refreshed Orders table and an hourly-refreshed Inventory table. The badge shows “Orders: 8h ago, Inventory: 20 min ago”, so viewers know which part is stale.1View0likes0Comments