Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I have a BPIX file that contain more then 10 tables.
In one table i have a column that I use sum measure in a card visual, the result is 3600 after refreshing it in the desktop.
when i publish it, and create a scheduled refresh, the number go down to 500
all the measures from diffrent tables are OK, its only that spacific table
something very weird, anyone had this issue?
I use that file for a year and everything was ok, just in the last 2 days.
maybe microsoft change something in the way pbi service refresh the data?
Thanks
Solved! Go to Solution.
Hi,
I solved the issue, I recreated the table and the problem has been fix.
PS, my gateway was up to date so its not related to the gateway
Hi Drors,
Is the result correct in your power bi desktop? If in power bi desktop the result is correct, update your gateway and restart your computer. In addtion, after schedule refreshed implemented, wait a few minutes and check if the value is correct. If the issue still occurs, could you please share some fiddler traces when the issue happpens?
Regards,
Jimmy Tao
Hi,
I solved the issue, I recreated the table and the problem has been fix.
PS, my gateway was up to date so its not related to the gateway
What's the data source?
I've had bad refreshes when connecting to SQL Linked Tables. The query completes with no errors, but the data from the linked table is incomplete.
You may also try updating to the latest version of the gateway...
Fred
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
117 | |
104 | |
77 | |
73 | |
50 |
User | Count |
---|---|
145 | |
109 | |
108 | |
90 | |
64 |