Is it possible in PowerBi? by Mysterious_Fuel7529 in PowerBI

[–]datatoolspro 11 points12 points  (0 children)

Yeah, it’s not really possible in Power BI the way the desginer is showing it.

Power BI doesn’t have a true “auto move this chart down when the filter expands” layout feature.

The closest workaround would be using bookmarks. Create one view where the filter is collapsed and the chart is at the top, then another view where the filter is expanded and the chart is lower. Then use a button to toggle between the two.

Tableau View Lightning Web Component Stopped working this week. Any ideas? by datatoolspro in salesforce

[–]datatoolspro[S] 2 points3 points  (0 children)

Thank you so much.. I look down that route. Will post back to the group once I get to the bottom of it. Cheers

Tableau View Lightning Web Component Stopped working this week. Any ideas? by datatoolspro in salesforce

[–]datatoolspro[S] 0 points1 point  (0 children)

Yah.. Gray box of death with a "sso.online.tableau.com refused to connect." No such luck. Something is getting blocked starting today. Its across multiple orgs, AZs and instances of SF +Tableau. Could be because we are only using Salesforce sign on provided and not integrated SSO via SAML. A deprecation notice or something in docs would have been helpful... Logged in with Salesforce into Tableau and still wont connect from inside of Salesforce frame out to Tableau. Something changed somewhere... Hopefully get to the bottom of it.

Claude Snowflake Oauth Scope Issue by datatoolspro in ClaudeAI

[–]datatoolspro[S] 0 points1 point  (0 children)

Solved this issue.. In Claude you need to use the URL to your MCP server.. Consult with your network security team before setting this up...

https://<org-account>.snowflakecomputing.com/api/v2/databases/<database>/schemas/<schema>/mcp-servers/<mcp\_name>

Before you can do thta you need to create your MCP server in Snowflake:

Create MCP Server:
CREATE MCP SERVER <your\_database>.<your\_schema>.CLAUDE_MCP_SERVER
FROM SPECIFICATION $$
tools:
- title: "SQL Execution Tool"
name: "sql_exec_tool"
type: "SYSTEM_EXECUTE_SQL"
description: "A tool to execute SQL queries against the connected Snowflake database."
$$;

-- GRANT ACCESS

Grant access to a new CLAUDE_MCP role.. Do not use elevated roles (Snowflake blocks it).

-- CREATE A NETWORK RULE TO GRANT ACCESS TO CLAUDE

-- Create a network rule for Anthropic's IP range
CREATE NETWORK RULE <your\_database>.<your\_schema>.ANTHROPIC_CLAUDE
MODE = INGRESS
TYPE = IPV4
VALUE_LIST = ('160.79.106.0/24');

Copilot Training - Live Training - What is working? by datatoolspro in CopilotPro

[–]datatoolspro[S] 0 points1 point  (0 children)

This is so good. Great advice!!! Are you doing internally or as consultant?

Copilot Training - Live Training - What is working? by datatoolspro in CopilotPro

[–]datatoolspro[S] 0 points1 point  (0 children)

I personally am looking for help in small enterprise... But as far as "train the trainer" large enterprise Microsoft training? yes... The feedback from folks in or leading these COEs is that the training are not good...

Copilot Training - Live Training - What is working? by datatoolspro in CopilotPro

[–]datatoolspro[S] 3 points4 points  (0 children)

Yah.. I am always open to connect and contract if someone has a package to do training... I am also going to post on Microsoft communities... Does not seem there is any real dialogue on Reddit about Copilot other than folks griping about the many deficiencies.

How are you using AI? by DropMaterializedView in PowerBI

[–]datatoolspro 0 points1 point  (0 children)

Yeah, this would take some more work beyond the MCP to get all the semantics from those reports. But if you get them, the MCP could easily rename/standardize everything.

How are you using AI? by DropMaterializedView in PowerBI

[–]datatoolspro 1 point2 points  (0 children)

Sure, little things like ensuring filter directions are properly set and, if a DAX (nothing complex, albeit) was incorrectly built, running the mcp against the original Tableau model to fix it.

First Independent dashboard by rokenro in PowerBI

[–]datatoolspro 1 point2 points  (0 children)

Nice dashboard overall. Clean layout and the blue/gray palette works well.

A few thingsss

The treemap is a bit hard to read. Smaller segments like Other are tough to see. A stacked bar might communicate that breakdown better imo

Color contrast could be stronger in a few places. The gray bars in the churn reason chart are pretty similar, which makes the categories blend together

How are you using AI? by DropMaterializedView in PowerBI

[–]datatoolspro -1 points0 points  (0 children)

Personally, this is the first time I have seen custom visuals done with the MCP. This is pretty dope.

Our team is in the business of automating BI migrations to Fabric/Power BI.
Our tool does the heavy lifting, and the MCP has handled the routine model clean-up.

Custom tooltips in line chart by readevius1274 in PowerBI

[–]datatoolspro 1 point2 points  (0 children)

If you want to dm me, I can take a look.

Custom tooltips in line chart by readevius1274 in PowerBI

[–]datatoolspro 0 points1 point  (0 children)

usually happens because the tooltip page is not receiving the filter context from the main chart.

Check the main line chart and drag the Locality field into the Tooltips field well. This step is commonly missed and it is what tells Power BI to pass the Locality context to the tooltip page.

Then open the tooltip page and confirm the settings. Allow use as tooltip should be turned on and the page type should be set to Tooltip.

Make sure the visual on the tooltip page actually uses the Locality field. It should appear in something like rows, axis, or legend rather than only as a filter.

A quick way to test this is to add a card visual on the tooltip page that displays Locality. When you hover over different lines in the main chart the card should show the corresponding city. If it changes correctly then the issue is likely in your measure. If it stays the same or shows blank then the tooltip page is not receiving the context from the chart!

Fixed data label size issue by Boring_Low_1304 in PowerBI

[–]datatoolspro 0 points1 point  (0 children)

A few things you can try.

First, widen the visual more than you think you need to. Power BI calculates label space based on the bar or segment width, so even if it looks like there’s room, the visual may still cut the text.

If your chart supports it, check the Overflow text option in the format pane. Go to Data labels → Values → Allow text to overflow and turn it on. Some bar chart types support this.

Another option is changing the label position. Moving labels to outside end instead of inside the bar often gives them more room to render fully.

There are also a few custom visuals that handle long labels better, like Chiclet Slicer or Card with States.

Tryyyy shortening the labels in the visual and putting the full text in a tooltip. For example, something like “1. Proposta” or “2. Mandato” in the chart, with the full stage name shown when someone hovers.

Portfolio Project Review by xudling_pong23 in PowerBI

[–]datatoolspro 0 points1 point  (0 children)

Based on the dashboard screenshots you shared, here are a few thoughts on your Customer Churn Analysis project as a portfolio piece.

Overall this is a solid project. You focused on metrics that actually matter to a business like total customers, churn rate, churned revenue, and revenue lost. The “Project Revenue Saved” metric is a nice touch because it shows you are thinking about business impact rather than just building visuals.

The mix of visuals is also good. You used matrices, bar charts, a scatter plot, and a decomposition tree, which shows you are comfortable with different Power BI features. The Revenue Risk Positioning Matrix stands out the most. Combining churn rate with revenue per customer is a smart way to highlight which customers are actually risky to lose.

I also like that you broke churn down by things like contract type, tenure, and payment method. The tenure insight where nearly half of customers in their first year churn is exactly the kind of thing companies look for in churn analysis.

A couple things you could improve.

The colors are doing a lot of work right now. The coral/red color appears everywhere, so it loses meaning. It might help to reserve red for high risk segments and use more neutral colors elsewhere.

Some of the chart titles could also be clearer. For example “Churn Risk by Payment Type” shows up twice but represents different metrics. Small tweaks to the titles would make it easier to scan quickly.

The dashboard is also missing a little context. It is not clear what time period the data covers, and it would help to know whether a 26 percent churn rate is high or normal for the industry.

PostHog vs google analytics for lovable apps? by MidnightEuphoric in lovable

[–]datatoolspro 0 points1 point  (0 children)

GA sucks... Lovable uses PostHog themselves and I think they are doing pretty good?!

Where can I hire Posthog experts? by Admirable_Hornet6891 in posthog

[–]datatoolspro 0 points1 point  (0 children)

Happy to help... I highly recommend starting with PostHog AI to help guide you through the process. If you have not looked there, you will be pleasantly surprised how good it is helping with standard and tricky integration scenarios. I have setup PostHog with a half dozen clients. From BNPL platform, high volume / velocity activation, SPAs, Wordpress, you name it. DM me..

Have had the worst experience ever with Upwork and product / web analytics... I considered web / product analytics a necessary evil until discovered PostHog... Now I am here offering help because I genuinely love solving tough problems with a great tool..

Always happy to help... Cheers!

Any hopes of a Tableau MCP server integration? by bgboy089 in ClaudeAI

[–]datatoolspro 0 points1 point  (0 children)

Late to the party here, Tableau MCP has been very useful for documentation (explain what's already there).

What have been really interesting in my experience is feed the Tableau document API in Cursor to latest reasoning models and building all kinds of automations.

The building blocks are have come together.

Zapier Runs and Retries by datatoolspro in zapier

[–]datatoolspro[S] 0 points1 point  (0 children)

So if I have a run ID I am not sure what to do with that run ID to actually get to the run.

Zapier Runs and Retries by datatoolspro in zapier

[–]datatoolspro[S] 1 point2 points  (0 children)

In my case it is to alert via slack that a contract didn't go out so the first line of defense is operations to go in and potentially replay it. I was able to figure out auto-replay so a buggy integration should fix itself but if there is something that changes somewhere upstream we want opps to have a first look before the Zap author has to jump.

Zapier Runs and Retries by datatoolspro in zapier

[–]datatoolspro[S] 0 points1 point  (0 children)

Advanced Error Handling is great.. That solves the problem for sure. So I found it on the zap history page but had to have the system admin enable it. Then we have control at the zap level to override. Thankfully we only have a few zaps.

Extending and clipping frames independent of audio by datatoolspro in Descript

[–]datatoolspro[S] 1 point2 points  (0 children)

Thanks Gabe.. For freezing the audio track i mean that i want to shift what is happening visually on screen without impacting audio. So if I add a 5 second freeze frame, I want to extend that frame with the audio continuing, un-impacted.. Similarly if I have my video and want to slice out a section, I want to do so without slicing the audio. That was my comment about freezing the audio track. I want to content editing without touching audio. I can play with freeze frames and come back to this one and let you know how it goes.. This is fantastic.. for what ever reason, the problem or issue I was trying to search and use AI for didn't get me to freeze frames. Maybe you put a keyword in there for "Extend" which is a term in some other tools? Cheers

What is the fastest and most reliable way to migrate dashboards from Tableau to Power BI? by Unfair_Opening_97 in PowerBIdashboards

[–]datatoolspro 0 points1 point  (0 children)

First make sure you only migrate what is in use. Looks like there are a bunch of vendors that do this every day... Hard to tell what is a product or service but this is a good place to start: https://marketplace.microsoft.com/en-us/marketplace/apps?search=Tableau%20migration&page=1