Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi All,
I'm having an issue where refreshing a query returns a doubled value. However, when my colleague refreshes the same query, it comes back with the correct values; I can send them the file and it's refreshed to the correct amounts, but if they send it back and I refresh again it is again doubled, which makes me think it's a setting and not an issue in the actual SQL code. Does anyone have an idea what I should be looking for?
Thanks!
Hi,
Ask your colleague to input his credentials on your computer. If the output will be correct then you should analyse sql if the views providing data have some restrictions based on user login. If not, try to just load data from both systems and compare tables one to one.
It is always tricky to find what's the reason for cases like this.
Artur
Unfortuantely, my colleague is on the other side of the world, so using their credentials on my computer isn't possible, but the SQL doesn't appear to contain any code relating to login.
Definitely tricky, but putting the table side by side shows exactly what I've described; the rows have the same descriptive values but the amount value is doubled exactly 2x.
Guess I'll keep looking through settings that might cause it.
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
10 | |
7 | |
6 | |
6 | |
6 |