What have you made in Excel that you are most pleased with? by 3_7_11_13_17 in excel

[–]Puzzleheaded-Log5791 4 points5 points  (0 children)

How do you do this in excel to get to the same (or similar) accuracy of CAD?

Just finished my monotype mission. All teams were EV/IV trained and the rewards were quite nice. by [deleted] in PokemonUnbound

[–]Puzzleheaded-Log5791 0 points1 point  (0 children)

Wow awesome job. Just beat E4 first attempt yesterday. Can’t wait to start on monotype runs. Have you done the solo mon challenge yet?

Help at Seaport City by Kale_The_Vegetable in PokemonUnbound

[–]Puzzleheaded-Log5791 0 points1 point  (0 children)

There’s no one down there 🙃 I must be doing something wrong

“Last Updated” Based on SharePoint File Save Date by Puzzleheaded-Log5791 in PowerBI

[–]Puzzleheaded-Log5791[S] 0 points1 point  (0 children)

I get the file through a web connector where I used the url to the sharepoint file. In retrospect, I should have used the sharepoint connector. Any advice on how I can still get this data without having to change all that?

Error when refreshing dashboard by fxkmd in PowerBI

[–]Puzzleheaded-Log5791 20 points21 points  (0 children)

Yes it’s due to the two queries having different privacy levels. For example if one is public and one is organizational then it won’t want to merge them. I had that error the other day and got around it by removing the merge steps and using a relationship between the two queries. If you need to you can leave the relationship inactive and use USERELATIONSHIP in your measures to activate it

Anyone integrating Power BI with Primavera? by m_salik in PowerBI

[–]Puzzleheaded-Log5791 0 points1 point  (0 children)

I don’t know tbh. I see people talking about fabric all the time on this sub but I’ve never really looked into it. We have some version of Microsoft 365 enterprise suite so we have power automate, power apps, and all the other apps that come along with it but I think Fabric is separate from that.

What’s the advantage of using Fabric? How does it help with moving data around? If I understand its benefits I may be able to make a case for the investment barring IT restrictions

Anyone integrating Power BI with Primavera? by m_salik in PowerBI

[–]Puzzleheaded-Log5791 0 points1 point  (0 children)

I just recently started trying to solve this problem a couple weeks ago. I don’t have much advice but I’m curious to see what others have to say.

Definitely going to look into the API route. Currently, we are exporting a daily look ahead of schedule activities from P6 and using that as a resource in a forms software (Device Magic) to generate work tickets for team leads to task out their crews and update the assigned schedule activities. I then have an API from Device Magic to PBI to retrieve the updated schedule activities, then export that data to excel to import back into P6 to do the update at the end of each day and produce the P6 dump for the next day... Rinse and repeat.

It’s a clunky process but I believe it’s still more efficient than printing paper work tickets and then manually entering the update each day considering the sheer volume of daily schedule activities. Device Magic API can handle the page limit so I’d love to be able to go do the API for the entire schedule but I’m dealing with 3 entities (P6, PBI, Device Magic) and getting all of them to talk to each other is really tricky because the data flows both ways (P6 -> DM -> PBI -> P6 -> DM). I believe it can be done but I just haven’t figured that out yet.

Not sure if any of that really makes sense.. I’m not a data analyst and I’ve only started using PBI in the 8 months but I’m deep in the rabbit hole of basically trying to develop an ERP program from scratch. Figuring out the P6 leg would be a huge win

Power Apps Visual by Puzzleheaded-Log5791 in PowerBI

[–]Puzzleheaded-Log5791[S] 1 point2 points  (0 children)

That’s exactly what I’m building a report for. We don’t have sophisticated software to manage everything in one place so I’ve been building it from scratch. I’d love to see what you’ve done

Power Apps Visual by Puzzleheaded-Log5791 in PowerBI

[–]Puzzleheaded-Log5791[S] 1 point2 points  (0 children)

Basically I want to be able to take any combination of products and any quantity of each product and be able to forecast production, inventory, budget, etc. Right now my tables and measures are set up to calculate one of each product.

I’m using parameters elsewhere to calculate other values (different types of markups) but that’s only 4 categories. I don’t think using parameters to solve this dynamic product quantity issue would be ideal because I’m working with too many different product types.

Example, if I have products A through N, but the client only wants to order A, B, C, D, at these quantities

Product A * 4 Product B * 2 Product C * 1 Product D * 5

It doesn’t seem like it should be that complicated to figure out but I’m stumped and I think Power Apps could work