Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello Everybody,
I have an issue with power bi desktop vs power bi service. I have a power bi pro account. I have a report that gets data from API's and sharepoint sites and I display this in both a report and some dashboards.
The refresh on power bi service doesn't show the same results as the refresh on power bi desktop. Except when I publish the report to power bi service it briefly shows the correct data, however it reverts back to the old data. Does anybody have any experience with this or has anybody encountered something similar?
Kind regards,
Ingmar Bolderink
Solved! Go to Solution.
Hello Both,
I found out that my dataset loaded the same amount of data (counts of hours per employee in this case) except the first and last documented date had an offset by one (desktop vs. service). I think power bi service and power bi desktop handle the parsing of date differently (european vs us date format or something). I changed all my date parsing and forced a dateformat on it and it seems to work. this was a very frustrating escercise. Thank you so much for your repsonse and thinking along with me!
Hi,
I am looking to do the same, can you please provide more details on the steps you performed to "... change all my date parsing and forced a date format..."
Thanks,
Tinna
Hi @Ingmar43 ,
On Service,did you directly get the data from Sharepoint online?If so,when you make changes on desktop,you need first to make a refresh in Sharepoint online,then make a refresh in Service,as the data in Service is synchronized with the data in Sharepoint online.
Hello Both,
I found out that my dataset loaded the same amount of data (counts of hours per employee in this case) except the first and last documented date had an offset by one (desktop vs. service). I think power bi service and power bi desktop handle the parsing of date differently (european vs us date format or something). I changed all my date parsing and forced a dateformat on it and it seems to work. this was a very frustrating escercise. Thank you so much for your repsonse and thinking along with me!
Hi @Ingmar43 ,
Great!So glad to hear that you have solved the issue,could you mark the reply as answered to close it?
Much appreciated.
Hi GilbertQ,
I only apply filters in the desktop version and then publish them. Even when I press Reset to Default I still get the differences. Even after republishing the report to a different workspace.