show and tell
41042 TopicsSnowflake: Different parameters in Power BI Desktop and Service after publishing for Warehouse
Hi everyone, we are using Power Query parameters for our Snowflake connection, including a parameter called SF_WARHOUSE. Our desired setup is: Power BI Desktop / local development: SF_WARHOUSE = DEV_WH Power BI Service: SF_WARHOUSE = POWERBI_WH The problem is that when a developer publishes/overwrites the report from Power BI Desktop, the parameter value from Desktop will be also be deployed to the PowerBI Service. We would like developers to permanently keep DEV_WH locally without having to remember to change the parameter to POWERBI_WH before every publish. We currently don't have Fabric/Premium Capacity, so Deployment Pipelines with deployment rules aren't an option for us. How do you handle this scenario? Is there a way to keep environment-specific parameter values in the Power BI Service when republishing from Desktop, or is it only possible over some kind of REST API / PowerShell automation (which might not be in real time)? Thanks!14Views0likes2CommentsDisplay personal bookmarks as a list on the report canvas
I want report viewers to create their own personal bookmarks and access them through a clickable list directly on the report canvas, instead of using the Bookmarks pane. The built-in bookmark navigator only supports report bookmarks, which viewers cannot create. Is there a way to display each user’s personal bookmarks within the report canvas, perhaps through a custom visual or another workaround?118Views2likes10CommentsCopy and Paste not Working in Service
Something has happened to my PowerBI report in Service since I last edited it 4 weeks ago. Not only am I unable to edit the commentary in the text box (because the toolbar positions itself inside the Text Box - see below), I am also unable to copy any text in service and paste it into Desktop, or anywhere, including a Word document, the paste option is greyed out. This is causing me a massive problem as I have a deadline for month end reporting today. .Solved44Views0likes5CommentsHow can AI agents improve Microsoft Fabric Data Factory pipeline automation?
I am exploring how AI agents can help make data pipeline development and monitoring more efficient in Microsoft Fabric Data Factory. Some potential use cases: Automatically creating pipeline workflows based on business requirements Detecting pipeline failures and suggesting fixes Optimizing data movement and transformation steps Monitoring data quality and identifying anomalies Triggering automated actions through APIs or external tools I would like to understand how teams are currently combining AI agents with Fabric Data Factory. Are you using: AI-assisted pipeline generation? Automated error analysis and recovery workflows? Fabric notebooks with AI models for data operations? Custom agents connected with Data Factory pipelines? Would appreciate insights, real-world examples, or architecture patterns from developers working with Fabric Data Factory automation.16Views0likes1CommentData Analyst Growth Path: Seeking Guidance After Passing PL-300 Exam
I’m excited to share that I recently passed the Microsoft PL-300 exam, which has been a significant step in my journey as a Data Analyst. To prepare, I relied heavily on a practice test Designed by P2PCerts' that helped me understand the exam format and strengthen my skills. The preparation process gave me valuable insights into data visualization, transforming raw data, and creating effective reports using Power BI. Now that I’ve achieved this milestone, I’m looking to further enhance my career in data analytics. I’d love to hear from the community: What certifications, skills, or tools should I explore next to stay ahead in this field? Any recommendations for advanced data analytics techniques or technologies to focus on? Your advice and insights would mean a lot as I plan my next steps. Thanks in advance!2.2KViews0likes4CommentsMaterialized Lake View Refresh activity Pipeline bug
Hi all, When using the preview feature refresh mlv activity in the pipeline, is do have some major bugs. After saving, it goes back to default, the pipeline does not want to refresh after, and I cannot parametrize it. Is there any workarround, and is this a known bug? Cause this is not workable.353Views0likes10CommentsNavigate Between Multiple Power BI Report Server Reports Inside Power BI Mobile App
Hello everyone, We are using Power BI Mobile with an on-premises Power BI Report Server. We have multiple Power BI reports, and we would like users to navigate from one report to another using buttons inside the reports. For example: Report 1 → Report 2 → Report 3 Our goal is to keep the navigation inside the Power BI Mobile app. Currently, when we use the normal Power BI Report Server report URL in a button, the link may open through the mobile web browser instead of opening the target report directly inside the Power BI Mobile app. Is there an officially supported way to navigate between different Power BI Report Server reports while staying inside the Power BI Mobile app? For example, is there a supported deep link, URL format, or another navigation method specifically for on-premises Power BI Report Server? Please note that we are using Power BI Report Server (on-premises), not the Power BI Service. Thank you for your help.157Views1like4CommentsCalculated function in Direct Query
I try to achieved this calculated column and work fine in Import Mode but In Direct Query it does not work for CALCULATE and REMOVEFILTERS. how could i possible to achieved it? Test = VAR CurrentDate = Workstation_HealthCheck[checked_at] VAR CurrentIndex = Workstation_HealthCheck[id] VAR PreviousDate = CALCULATE ( MAX ( Workstation_HealthCheck[checked_at] ), Workstation_HealthCheck[id] = CurrentIndex - 2, REMOVEFILTERS ( Workstation_HealthCheck ) ) VAR TimeDifference = DATEDIFF ( PreviousDate, CurrentDate, HOUR ) RETURN IF ( ISBLANK ( PreviousDate ), "UP", -- Or "First Check-in" IF ( TimeDifference > 4, "DOWN", "UP" ) )42Views2likes1CommentCalculated function in Direct Query
I try to achieved this calculated column and work fine in Import Mode but In Direct Query it does not work for CALCULATE and REMOVEFILTERS. how could i possible to achieved it? Test = VAR CurrentDate = Workstation_HealthCheck[checked_at] VAR CurrentIndex = Workstation_HealthCheck[id] VAR PreviousDate = CALCULATE ( MAX ( Workstation_HealthCheck[checked_at] ), Workstation_HealthCheck[id] = CurrentIndex - 2, REMOVEFILTERS ( Workstation_HealthCheck ) ) VAR TimeDifference = DATEDIFF ( PreviousDate, CurrentDate, HOUR ) RETURN IF ( ISBLANK ( PreviousDate ), "UP", -- Or "First Check-in" IF ( TimeDifference > 4, "DOWN", "UP" ) )Solved70Views1like2Comments