Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Different data between Power BI Desktop and Power BI Service after the upload

Hello,   I´ve got a problem with my uploaded data. When I actualize the data in Power BI Desktop and look later on the data in Power BI Service, I have a different number of the available hours for...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

I am having the exact same problem as nwrong , ttvd  and possibly Anonymous . A short summary:

- When refreshing data in PBI Desktop I get expected results

- When I publish the report to PBI Service with no refresh, the results are also as expected

- When refreshing the data in PBI service (manually/scheduled), a large portion of the data from the DWH table is missing

 

Some details about my data: I have two data sources in my report that are merged in PowerQuery, a DWH table and a csv file stored on a shared disk location. The DWH table is updated every night and the csv file is static.

 

The issue is not that the data source is updated as I do these checks during daytime, and there is no issue related to time zones. The worrying fact is that no error message arises, so the issue could potentially go under someone's radar.

 

At the moment I have disabled scheduled refresh, do manual refresh PBI Desktop daily and republish to PBI Service every morning. Has anyone opened a ticket to Microsoft regarding this behavior?

Salvador's avatar
Salvador
Responsive Resident
5 years ago

Hello Anonymous,

 

One quick question, the data refresh on the pbi service is using the same credentials you use to refresh the data in pbi desktop?

 

I once had this issue, and the cause was that the credentials used in pbi service didnt have access to the same information my credentials had.

 

Regards,

Salva.