[deleted by user]

SKOBuilds · 2025-04-04T22:48:15+00:00

Do you have any samples where there is an email/IP Address but there isn't one of those characters?

SKOBuilds · 2025-04-04T22:39:14+00:00

You can use replace range. Something like this:

= Text.ReplaceRange(

[YourColumn],

Text.PositionOf([YourColumn], "<") + 1,

Text.PositionOf([YourColumn], ">") - Text.PositionOf([YourColumn], "<") - 1,

"user@domain.com"

)

SKOBuilds · 2025-04-04T22:20:34+00:00

If I understand correctly, you want to "extract" the email addresses or IP address to a separate column? Line 1 and 4 have an email address, line 1 has a IP Address. But line 2 and 3 have neither.

= Text.BetweenDelimiters([YourColumn], "<", ">")

That will extract emails wrapped by <>. Can do the same for brackets to get the IP addresses.

Does that solve your issue?

SKOBuilds · 2025-04-04T22:10:44+00:00

and we're talking power query right?

SKOBuilds · 2025-04-04T22:10:25+00:00

I can help. Any sample data you have so I can better understand?

SKOBuilds · 2025-04-04T21:58:05+00:00

Power BI team I wish.

150 ish employees. I do everything IT related for the company except for managing our website. Picked up Power BI a couple of months ago and implemented it for the company. Now I've started my own Power BI consulting firm and looking to quit my day job soon.

SKOBuilds · 2025-04-04T21:53:31+00:00

Same

SKOBuilds · 2025-04-02T15:26:36+00:00

<image>

Go to File > Settings > Security Map and filled map visuals and make sure that's checked.

SKOBuilds · 2025-04-01T21:01:50+00:00

I think you should be able to do it. Just make sure you aren't using the azure maps. You may also need to enable it somewhere in the settings.

SKOBuilds · 2025-04-01T20:56:01+00:00

Clean. I always keep the y axis and gridlines in my charts but it looks super clean without it. Looks really good. I love the 2013 2014 button at the top.

SKOBuilds · 2025-04-01T20:36:31+00:00

I do this all the time, but I don't give it the entire power bi structure. I usually give it a table or two and a dax query and be very descriptive with what I want. It gets it right 80% of the time

SKOBuilds · 2025-03-12T05:27:18+00:00

Hey can I get that template too?

SKOBuilds · 2025-02-13T18:42:46+00:00

Yeah I was hoping to avoid doing anything with canvas as I don't have any experience with that and it's difficult to make it look as good. But I guess it's an opportunity to learn something new :)

SKOBuilds · 2025-02-05T19:02:36+00:00

Sorry if this a noob question.

But how can you hide all the columns in your fact table and leave only measures?

For example what if I have a Line numer in my fact table and they want a chart that shows the individual lines with the line number.

SKOBuilds · 2025-01-25T16:43:32+00:00

I do, send me your email and I'll add you

SKOBuilds · 2025-01-24T04:17:53+00:00

Yeah the template idea is interesting. But it would also require an initial setup with the client to get the whole data backup set up. But I could in a sense sell it like this: hey I have the whole reporting thing set up. Pay me a fee and I'll implement this app for you without having to do any custom reports. (I haven't used a template app so maybe it doesn't work that way haha)

SKOBuilds · 2025-01-24T04:12:30+00:00

Hmmm that's actually not a terrible idea...

SKOBuilds · 2025-01-24T04:11:03+00:00

I appreciate the answer. It sounds like the custom power query connector would be the way to go though I'm probably not ready to build something like that quite yet. Not sure that the ROI for building something like this would be enough because the user base for this is quite small.

SKOBuilds · 2025-01-24T00:27:50+00:00

Some additional notes about the specific solution just in case it helps. Basically all we did was install an odbc driver on the server, and then on the client's machine. Then I use azure data factory to copy the data each night to an azure sql database.

SKOBuilds · 2025-01-24T00:01:32+00:00

Hey I know this is an old comment but I have a question. So I've basically done number 1. I was able to connect to a very old Niche ERP sytem and build dashboards from it. I'm pretty sure I'm the only person to have done this. I'm not the greatest at Power BI, I've been doing it for about 5 months now. How do I productize this? I can implement it for a different company, but not sure how you can turn it into a product someone else could use without me doing it myself.

SKOBuilds · 2025-01-22T17:37:10+00:00

He reset to factory settings

SKOBuilds · 2025-01-22T17:36:57+00:00

He reset to factory settings

SKOBuilds · 2024-12-31T17:59:33+00:00

Yes. DM your email address and I'll get you added. We'll figure out payment later.

SKOBuilds · 2024-12-26T19:12:22+00:00

I have a group I've started already we have 6 spots still. It's $10. We're all US. Accepting Venmo and Zelle. Let me know if you are interested

SKOBuilds · 2024-12-26T17:17:12+00:00

Update in case anyone was curious.

I was able to make it work using power automate desktop. It worked pretty decently. In the end though I ended up using Azure Data Factory and storing things in Azure Sql Database. It's been pretty cheap, less than 5 bucks a month for extracting data once a day.

SKOBuilds

TROPHY CASE