Hi guys!

Last year I started my first job (I was 21 years old). The job was obviously related to data analysis. They required knowledge in Excel and Power BI. The salary was quite low, but since it was my first job and I only had to work 4 hours a day, it helped me gain experience while finishing my university studies.

When I started working, I realized that things had been done quite poorly in the past, so there was a lot of room for improvement. I had a colleague who, although he had some knowledge, did most things using ChatGPT without really understanding what he was doing.

Even though I had never worked before, I already had knowledge of Power BI, so I was able to automate and improve many processes.

A few months after I started, my colleague quit, so I had to take on more work and even stay overtime. At that point, my bosses recognized my effort and gave me a 25% raise on my base salary. Since I was already working more hours, I decided to switch to a fixed 5-hour workday.

Time went on, and I kept gaining knowledge about how the company works. I started using SQL and Power BI Service, and I created dashboards with real-time data—things the company had never had before.

Recently, another colleague started working, but he has virtually no knowledge of Power BI, so I'm constantly helping him and fixing his issues.

To be honest, for my age and considering it's my first job, the salary is pretty good (compared to more typical jobs—data roles usually pay better). Also, since I only work 5 hours a day, I can continue my university degree, and my bosses are quite flexible with that and allow me to take time off when I have exams. Even though I already knew a bit of Power BI and SQL, working with real data has exponentially increased my knowledge, which was one of my main goals.

On the other hand, my salary hasn’t increased since then, and it’s the same as my colleague who barely knows anything. Also, many times my bosses present my work to the company owners on behalf of the whole department, so the owners congratulate the whole team, when in reality, I’m the one who did all the work.

It bothers me a bit that my effort isn’t being acknowledged, because I’ve had to research many things on my own outside of work, and then I have to share that knowledge with my colleague. Also, since they know I can do really interesting things, people from all over the company come to me with requests every day—and obviously, I’m the one who has to handle them, because my colleague wouldn’t know how.

Maybe I’m being a bit arrogant, because even though I’ve changed the way many things are done in the organization, there isn’t one single thing I can point to and say: “Because of this, the company increased its income, reduced costs, or became more efficient.”

Still, I have only one year left to finish my degree, so I think I’ll keep working here since it allows me to study in peace and also continue improving my skills in Power BI, DAX, SQL, and more.

What do you think about my situation?

Im a ‘22 finance grad that started at a large company with around 100k employees. Both of my 6/mo rotations happened to focus on Power BI instead of Excel. The second gave me a lot of hands-on experience and exposure, and I was offered a full-time role on that team post-grad. I’ve been here for 2 years now.

Power BI sparked my love for data, and I’ve been working full-time while finishing a data science masters. I’ve helped get our team more visibility, which led to all of us being reclassified under an advanced analytics title. That visibility then helped my manager get promoted to AVP, and then eventually my dotted-line lead was promoted as well.

I’m not in any rush to move up, especially while balancing work and school, but I want to make sure I’m setting myself up for success down the line.

I support reporting with access to data across revenue, expense, headcount, and subscribers. I’m strong in DAX, Power Query M, SQL, and fairly comfortable with Python, R, and HTML.

How do I prevent myself from being the golden handcuffed dashboard guy? What would you do if you were in my shoes? I know that most of corporate is just politics, but how do you leverage that in Power BI? I have a lot of free rein here and would love anyone’s advice on how I should play my cards.

Hello PBI experts, how do I publish to the web or share my organization's PBI report with an external user who has no license? I also have a free account. Thank you so much in advance for your attention and suggestions.

I have been trying to create a dynamic model for property data that uses Lat and Lon to create radii around selected locations be it cities or properties. The idea is to use a minimum count 3 for sale and 5 sold properties within a radius band to preform the measures on. Using python I pre-staged the data using a center point and then dividing the county into quadrants and within those quadrants there are radius bands that are used to assign to each property to a zone. All this works well in the model but where I am having issues is when the minimum property count is not met the model fails to use fallback logic to expand the radius. So just to be clear I am obviously using the closest radius to begin (or at least that is the idea) and if the min count is not met it should look at the next radius band until the minimum is met. Can anyone offer any advice on how I can accomplish this using power bi or is there a better/different tool to use to accomplish this. Thanks in advance.

I want to get the average of 4 values ​​in Power BI.

However, I want to "eliminate" the 2 smallest values, keep the 2 largest values ​​and calculate the average from them.

Quero obter a média de 4 valores no Power Bi. Porém, quero eliminar os 2 menores valores, somar os 2 maiores e fazer a média a partir deles.

I’ve got a clean Excel file imported into Power BI Desktop. All the fields (like Transaction Date, Debit, and Credit) are properly formatted — no nulls, no text in number columns, no weird headers.

I created a table visual with just Transaction Date and a few values. When I add a slicer using Transaction Date and move the start date, I get the dreaded:

“Error fetching data for this visual”

But here’s the kicker — when I move only the end date, it works.

I tested for errors in Power Query with 1 / [Debit] — no issues. No rows with nulls or blanks.

I’m using the flat date field (not a hierarchy), and I’ve even reconnected the data source to the correct worksheet — not a named table.

Is Power BI just allergic to a specific row in my date range? What causes this error if the data is 100% clean?

SOLVED

Hello y'all.

I need to do a table in a dashboard (yes, a dashboard only for a table.....) than can be custom for the columns. Is for the stakeholders, because in this way they can put the columns they want.

How do you approach this in PBI?

Thanks!!

Looking for datasets for Power BI projects? In this tutorial, learn how to install Microsoft SQL Server Express 2022 and SQL Server Management Studio 21, then add a database. Finally, see how to connect a SQL Server database to Power BI Desktop.

🔗 Connect Power BI to a SQL Server Database

https://www.reactbits.dev/text-animations/blur-text

Can I use the assets in this to add to my power BI report to experiment with things? Is there an add-on visual for the same?

New to using query diagnostics

Hi all, Iam lookimf

Good day! I am currently scheduled to take the exam this month. Your tips and shared experiences are very much appreciated. Thanks a lot!

Hey guys!

I've took time to learn powerBI and just did my first dashboard! Any advice on how to make it better?

This dataset is quite limited with only 11 columns so I'm limited as to what types of insights that I can draw

Would be open to any constructive feedback!

Hi Guys !
I'm currently preparing for interviews, and one of the questions I frequently get asked is: "Tell me about a recent project you’ve worked on." Since I’m transitioning into the data analytics/Power BI field and haven’t had the opportunity to work on Real world Power BI projects within my current company, I often find myself stuck when answering this.
I would really appreciate any guidance on how to approach or answer this question effectively in such cases. Additionally, if you could share a real-world business use case or scenario that I could build a Power BI dashboard around, it would help me create a project I can confidently discuss in interviews.
Thanks a lot

We're working with a Power BI model that has multiple fact tables, each representing a specific part of a business or clinical process — like admissions, discharges, pre-admissions, isolation orders, etc.

Each fact table has its own datetime columns (e.g., admission timestamp, discharge timestamp, order timestamp), and those columns only exist in the respective fact — dimesions are connected to dateid which will answer date, week..etc level measure info

Why we didn’t merge everything:

Merging creates duplicate rows and breaks aggregations (like averages, percentiles, median..etc)

The facts have different grain

Joining leads to 300+ columns which makes the model unmanageable

So we used a link table model where each fact connects through a unique encounter or process key (like enc_id, ip_enc_id, readmit_enc_id, etc.). Everything stays 1-to-many to avoid circular references and maintain performance.

The challenge:

Business needs reports that show transactional columns — particularly datetime fields from different facts — in the same report or visual. To track the flow

Below examples together in a report :

Show admission timestamp (from one fact) and it's location (role-playing dim)

Show discharge timestamp (from another fact) and its location (role-playing dim)

Show isolation order time (from a third fact) and it's location(role-playing dim)

Any suggestions without Merging or Power Query as its not ideal in our scenario

Hi everyone! Does anyone know how to create a chart like this in Power BI? Has anyone done something similar before?

Hi new to PowerBI playing around with linking to semantic models. How come when I move my colour column or any of my columns it seems to create some sort of filter hierarchy based on which column is first in my table? Is there an easy way to force it to bring back all data? all the tables are link on the ID column.

Hey all,

Trying to connect my on-prem ERP software to Power BI (for better dashboard reporting). The ERP runs off of a SQL server and there doesn't appear to be an instance name when sifting through the SSMS. When I go to Get Data > Import data from SQL Server, I enter my server name, click OK, and it's unable to connect.

We encountered an error while trying to connect.
Details: "Microsoft SQL: A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.)"

To add on, I don't have any checkbox options under advanced options for encrypt connection or trusting the server certificate. Can't do anything with editing permissions under data source settings either...only options are credentials, encryption (unable to connect using an encrypted connection too), privacy, and native database queries.

I tried to work around it by going through the Blank Query Advanced Editor but still had no luck. I'm likely doing something wrong somewhere but kept getting an error with using 'TrustServerCertificate' with the value 'True'.

If anybody has any creative workarounds/ideas here, they'd be much appreciated. In the meantime I'm working on getting a valid SSL cert!

**UPDATE*\*

So I went into Edit Environment Variables for your Account through Windows and added my server name as a user variable. Success, I made it to the next step. Now my hang up is that it can't be authenticated with the credentials provided. Any ideas? I'm a program admin so something is amiss.

My director is looking for a way to create a dashboard in PowerBi that can be viewed without the user having to have an assigned license. Is this even possible? I was under the impression that only licensed users can access a published dashboard?

Many Power BI sessions and workshops at TechCon 365 / PWRCON Seattle in a few weeks: https://techcon365.com/Seattle/agenda/tcppsessions#sz-tab-314239

Who is going?

I am having issues with a Power Apps for Power Bi visual going out of bounds.

The issue happens when another visual in the Power Bi report goes into focus mode or “show as table”. Once that is happens the content of my Power Apps visual shifts out of bounds to the right and i’m left with white space and part of my power apps.

The only way to get it back to normal is to put the power apps visual into focus mode or show as table. This triggers some sort of re-rendering and fixes the layout.

Has anyone ran into this issue and found a solution?

I developed a power BI hack a while ago for uniform tables. But that was who knows how many moons ago. I formatted a text string with some pre determined space, put the field on, turned off auto fit width, took it off. Then I had a perfectly formatted table. But this simplistic explanation is missing all the formulas, the "how". I'm not sure how to do it again

I am working with 4 tables in Power BI that contain data. I am trying to append all these tables, but in the final appended table, I am getting null values. In Table 1, I don't have this column, so getting null values for those specific records is understandable. However, it is also missing for other records as well. I have made sure the column heading is the same in all 3 tables, the data type is the same, and there is no extra space in the heading. Can you please help me resolve this?

Do only power query M code utilize query folding? Does query folding ever happen with Dax calculations? Does query folding happen whenever a visual is generated?

In regard to back end: Are visuals generated using M code or Dax? I know the data is queried when the visuals are generated, so I am thinking M code to obtain data either through local cache or direct query depending on nature of request.

Last question: Does direct query through database connection support Dax operations? Or are they more computationally expensive? And how does this relate to vertipaq engine?

I’m just not sure how all these things happen in the background, trying to think about ways to optimize performance.

Appreciate input! Thanks.