Hello Power BI Community,
Have you experaince ever different results in Online refresh (Manul or scheudled) vs manual refresh in PBIX?
We are pulling data via OData feed from our accounting package.
When we refresh data online all is good.
When we publish that data set to our workspace and than schedueld refershs than several transcations are missging which cause panic in my organisation as business can't see posted invocies.
As temp solution we have stopped schedueld refreshes which are much faster and we are performing only manul ones.
I am not sure if issue is with OData feed if manual refersh via PBIX is fine.
Hello @Burningsuit ,
I have submitted again the credential and there is still same problem.
It's very strange one.
I have report 1 where pbix refresh is ok and online not (on demand or scheduled) - some transactions are missing
I have report 2 where pbix refresh is ok and online is ok as well.
Same OData feeds, same credentials Report 1 has problem with online refresh and Report 2 is fine.
My problem is that Report 1 is now my central report with so many points and my whole company is interacting with this key report. (Yes it is bit bigger 118MB and 132 pages) but manual refresh brings right results.
I have there complex RLS and page Level security via RLS as part of audience have access to whole report and another part of audience only to part of the reports.
I can't get my head around this.
There is no Gateway as data are in cloud and Report 2 with same OData feed is fine. ( That report is bit smaller 66MB and around 14 pages)
I assume that that number of pages shouldn’t affect online refresh? right?
I am maybe planning to reset my credential over weekend and generate new passwords but I worry that outcome will be the same.
I have never experienced this.
I am quite lost as I have been working on this project for last few weeks and I have merged several reports into one so people can access all in one place.
This is indeed odd.
If you have a Report where both PBIX refresh and Online refresh work that implies the refeshing is working correctly, and it's not a credentials issue.
But you also have a report which shows different data between a PBIX refresh and an Online refresh.
My first question is, do both these reports share the same Dataset ? If they do, then it's really wierd and I'd call in Microsoft support to help.
However if these two reports are based on two different Datasets, then there may be a reason.
In Dataset 2, for Report 2 (the one that shows a difference between PBIX and Online refresh) do you filter data by Date ? If so, are you aware that the cloud service uses UTC Date/Time rather than Local Date/Time. If you are comparing against Today() or other date time basis to create a Filter, that may be a reason why online differs from PBIX refresh. Just a thought.
As I say though, you may be in a situation where you should get Microsoft support involved, use this link: https://powerbi.microsoft.com/en-us/support/pro/
Hope this helps
Hello Stuart @Burningsuit,
It is same dataset.
You are right it might be one for Microsoft Support.
This seems to be beyond Power BI Community.
Many thanks for your help.
I think this may be down to the Gateway settings for refresh.
If you refresh on Power BI desktop, you are connecting to your Odata feed, probabaly with that users set of credentials which allows access to all data, so you get all the accounting data and everyone is happy when that is Published.
However, to use Automatic Refresh in the cloud for the Odata source, you probably have a Gateway set up and that Gateway is using a different set of credentials to connect to the Odata source, so is reading a restricted set of data that does not have access to all data, so you get "missing" data.
I suggest you look at the credentials used to connect on the PBIX and the credentials used to connect via the Gateway online, you may find your solution there.
Hope this helps
Hello @Burningsuit ,
You are right. Manual PBIX refresh is fine.
We don't have Gateway connection as data are sourced in cloud.
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.