Forum Discussion

lT-Guy's avatar
lT-Guy
New Member
8 years ago

On-premise data gateway (personal mode) - missing data after refresh

I have some PowerBI reports which depend on the data stored in Excel sheets which are stored on-premise. To avoid every day manually updating the report in the Desktop App and publishing it to the T...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

lT-Guy,

You can share dummy data to us.

Regards,
Lydia

lT-Guy's avatar
lT-Guy
New Member
8 years ago

Hello Anonymous

 

I have prepared a dummy data set in the meantime and did some testing with it. The Excel sheet has the same columns as the live data set but far less and of course meaning less data in it. I first thought that the volume of data is the problem. Because I have reports depending also on Excel sheets but with only 1 MB in size. There the update process using the On-Prem gateway is working fine. I tested wit the existing report and also created a new report based on the dummy data set. With the existing and the new report, refreshing the dataset using the gateway destroys most of the data in it. Only refreshing the report in the desktop application and publishing it to the Power BI Workspace results in a fully working report.

 

I will try to share the Excel sheet through OneDrive with you, as I could not find a option for attaching a file.

 

Best regards, Gerhard