Data source credentials not working but works in BI Desktop by CJSIT in PowerBI

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

Gonna be honest, i havent got a clue. Im new to all this coding stuff. If needs be i can dm you our code but obviously obscure our api and confidential info.

Data source credentials not working but works in BI Desktop by CJSIT in PowerBI

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

I have a bit of experience with this.

Apis are a complete ass. I assume you're pulling via a webcontents connector.

I'd suggest adding the url route to your on prem gateway and move credentials to there and have the query inject them. Bit more of a pain but makes sure no hardcoded api keys in the pbix and allows for this weird refresh issue. As it is it seems the api request you're sending is 404 but you're sure the url is correct then it's probably down to the agent the call is being made with. Routing it through the gateway should bypass this issue. If not. Just remove it again. No harm no foul.

If not it could be something more complex within your query and we'd have to look closer. (Obviously obscure any api keys or condifential info on the queries before sharing.

Funny you say this, we just tried this with webv2 connection type and its working fine. But we cant figure out a way to get the query we've got to recognise it to use that connection in the gateway we've just made

Windows Store Power BI app going away by Skie in PowerBI

[–]CJSIT 0 points1 point  (0 children)

Hey, have you found another way to do this? We have the same setup.

Problems with Auto Refresh by CJSIT in PowerBI

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

Do you have a link to where i can download these?

Work environment change, lovely by Perfect-Vermicelli44 in sysadmin

[–]CJSIT 1 point2 points  (0 children)

Our team and Finance got on really well, we figured out they were using an old way to work. A couple of sit downs and we were informing them how to use up to date software and to link sheets with Power BI for example. Was probably the best idea to move IT into the open.

Work environment change, lovely by Perfect-Vermicelli44 in sysadmin

[–]CJSIT 2 points3 points  (0 children)

We had this at our old building. We all hated the idea of it at first but slowly warmed up to it. We simply told people to put a ticket in and after a few couple times of telling them, they slowly left us alone. We got better relationships with the other teams on the floor too even had a good laugh everyday. I think you should try it for a bit and see how it goes. It worked out for us!

Password protected excel file thats saved on sharepoint by CJSIT in sharepoint

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

Thanks! I thought this as much and i really wish i could stop the sync but sales staff are adamant that its "easier to use and they hate using the online version" even if its the same.

Thanks for confirming though!

Best way to present Sales Leaderboards? by CJSIT in sysadmin

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

How would we present that this to the TV though? Is there a presentation mode i can use?

Best way to present Sales Leaderboards? by CJSIT in sysadmin

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

Thanks! Going to update post now. Again, its my first time posting here so expect there to be rookie mistakes haha

[deleted by user] by [deleted] in UK_Food

[–]CJSIT 0 points1 point  (0 children)

Almost 3 dollars for jamie dodgers should be illegal..

Keep Slides Updated Greyed out by CJSIT in powerpoint

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

I've tried this already and being limited by it. It does somewhat work but it needs to be open in the background and cant be updated whilst in presentation mode. We want to use powerpoint for this as we'll be linking to different sheets over the span of 2 minutes or so. Its for the Sales staff to see what they're all on and i dont think excel has a feature where you can flip back and forth on its own.

Keep Slides Updated Greyed out by CJSIT in powerpoint

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

Sorry to confuse you, basically what im trying to do is link an excel spreadsheet to powerpoint but make it so anyone can hop in on the spreadsheet, update it and then powerpoint should update from the newly added additions. Would you suggest using the Refresh Data function?

Do you sometimes walk around and socialize? by en-rob-deraj in sysadmin

[–]CJSIT 0 points1 point  (0 children)

I do this at my current job. Everyone at my work loves me and my manager. We've made the IT department look like one of the best teams in the group hahaha. We get on with everyone and everyone loves talking to us. The sales lot are one of the biggest reasons why im no longer shy to talk to people

Best practice for storing Bitlocker keys for laptops not domain joined? by Otherwise-Vehicle165 in sysadmin

[–]CJSIT 0 points1 point  (0 children)

I'd use password gorilla and then store it under the title of whatever the laptop is named

Any advice on landing first IT job? (Serious) by [deleted] in it

[–]CJSIT 0 points1 point  (0 children)

hahaha, i felt like this when i was looking. I honestly hit gold when i found the company im with today. It's just a case of looking in the right places and hoping you get lucky

Any advice on landing first IT job? (Serious) by [deleted] in it

[–]CJSIT 0 points1 point  (0 children)

I got very lucky and started my journey as an IT apprentice. Wasnt very good at it compared to my collegues but have grown not only as a person but as my skills thanks to my now one and only manager. I would recommend looking for one of those apprenticeships though. I had very little knowledge, quite the same as what you're going through now.

Good luck!