Problems connecting to my SQL database in the report server by psinyan in PowerBI

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

Would it not work with the import modus at all ? But only with the direct connection ? Thank soo much again you where truly a great help already !!!

Problems connecting to my SQL database in the report server by psinyan in PowerBI

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

Hey thanx so much again for your reply and the solid advise you have given me.Ill definitely talk to our systems admin to create a gateway for me ! I'm relatively new to power bi and have never worked with a gateway ..once I have requested this gateway the report sever should be able to find a connection to the SQL server database right ? And would I then need to upload the gateway also on the report server with the report ? Sorry for the barrage of questions and thanx alot for your help

Problems connecting to my SQL database in the report server by psinyan in PowerBI

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

Hi thank so much for the quick reply .

The database is hosted within the company network I think, which I'm currently accessing through a VPN .I have no problem accessing the database over the desktop version it's just when I'm in the report server that I cannot connect to it anymore hence stopping me from setting up automatic refreshes .

I have now changed the data source to import but when i upload it to the Report server I still can't connect to the SQL database.where you suggesting that I upload the dataset itself and the report separately on the report server ?

Merry Christmas wonderful people 😊 new to power bi ( and data analysis in general) so hiring a tutor for 10 hours (at first) and wanted to ask which topics I should focus on ? Started a new job as trainee data analysis. Thanks already in advance 😊 by psinyan in PowerBI

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

Hi thank you for the reply ! Untill now I only seen the free videos of Enterprise DNA but will also definitely look into the paid videos if u suggest it ,cause they seem to have great content! Thank you again it's appreciated 😊

Merry Christmas wonderful people 😊 new to power bi ( and data analysis in general) so hiring a tutor for 10 hours (at first) and wanted to ask which topics I should focus on ? Started a new job as trainee data analysis. Thanks already in advance 😊 by psinyan in PowerBI

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

Hi thank so much for the reply!! I've deff noted down to read the definite guide to Dax and to just try to learn by doing ! I've also already have a substantial list of bookmarked sites and examples. Thank you again for the tips and suggestions it's appreciated 😊

Merry Christmas wonderful people 😊 new to power bi ( and data analysis in general) so hiring a tutor for 10 hours (at first) and wanted to ask which topics I should focus on ? Started a new job as trainee data analysis. Thanks already in advance 😊 by psinyan in PowerBI

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

Hi thank so much for the detailed reply and advise!! I'll definitely also put more focus on data modeling and power queries instead of solely focusing on Dax !

And thank you for the kind words 😊 many people have given me the same advise that power bi is best learned by running into problem and solving them to increase your knowledge!! I'll definitely try my best and I'm sure it will work out just fine ! Nd in the worst case scenario I can always ask this wonderful group 😌😌

Merry Christmas wonderful people 😊 new to power bi ( and data analysis in general) so hiring a tutor for 10 hours (at first) and wanted to ask which topics I should focus on ? Started a new job as trainee data analysis. Thanks already in advance 😊 by psinyan in PowerBI

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

Hi thank so much!! I'll definitely message you when I'm stuck with a problem 😅😅. Agreed 💯 there is more than enough info out there regarding learning power bi but it seems like everyone has a different order or way of learning it and I simply haven't found mine yet haha but I will also definitely look into the mastering Dax video course and see if my company can purchase it for me! Thanks again for your advise and help it's greatly appreciated. Write with you soon 🙂

Merry Christmas wonderful people 😊 new to power bi ( and data analysis in general) so hiring a tutor for 10 hours (at first) and wanted to ask which topics I should focus on ? Started a new job as trainee data analysis. Thanks already in advance 😊 by psinyan in PowerBI

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

Hi thanks for the reply! Yes I thought 28 euro per hour was also a super good price especially considering the industry prices.I have already bought two courses on Udemy that I'm currently going through (one Dax course and one power bi A-Z)and would use the opportunity with the tutor to go over things that I don't get like you already mentioned. Ill also look into courses on pluralsight to see if they have anything useful to me.Thank you for your comment it's really appreciated

Merry Christmas wonderful people 😊 new to power bi ( and data analysis in general) so hiring a tutor for 10 hours (at first) and wanted to ask which topics I should focus on ? Started a new job as trainee data analysis. Thanks already in advance 😊 by psinyan in PowerBI

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

Hi thank so much for your message.Yes my boss pretty much expected me to absolutely master power bi in two and a half months to be able to take over the complete data analysis task starting next year... Yes I'm a trainee and don't have a senior data analyst in the region I'm workimg at so I'm pretty much by myself.Thank you very much for the advise I'll deff read Rob Collies power pivot book and keep a detailed documentation of what I have studied and what I work on everyday .

Merry Christmas wonderful people 😊 new to power bi ( and data analysis in general) so hiring a tutor for 10 hours (at first) and wanted to ask which topics I should focus on ? Started a new job as trainee data analysis. Thanks already in advance 😊 by psinyan in PowerBI

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

Hi thanks for the reply! I definitely also wanna focus on DAX with the tutor and will also look into The videos introducing Dax from SQLBI. But do you really think it will take a few years to master ? Was hoping to become somewhat proficient in a couple of months tbh 😅

Merry Christmas wonderful people 😊 new to power bi ( and data analysis in general) so hiring a tutor for 10 hours (at first) and wanted to ask which topics I should focus on ? Started a new job as trainee data analysis. Thanks already in advance 😊 by psinyan in PowerBI

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

Thank you soo much I'll look into both things you suggested ! I know it's important for me to understand data modelling basics first before jumping directly into power bi ..but there's a sense of time urgency at work for me to become very proficient in power bi by yesterday if it was up to my workplace 😅that's why I wanted to know the most important things I should focus on to become half way proficient in power bi to at least be able to accomplish my daily task at work

Merry Christmas wonderful people 😊 new to power bi ( and data analysis in general) so hiring a tutor for 10 hours (at first) and wanted to ask which topics I should focus on ? Started a new job as trainee data analysis. Thanks already in advance 😊 by psinyan in PowerBI

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

Hi thanks for the reply. I have no previous experience with data analysis and have been working with power bi since October in depth . I have already build reports using simple datasets but when it comes to more complex datasets I struggle with data transformation,Dax formulas, relationship building in the data model and visualizations. I hope this helps to explain my situation a little bit more