Forum Discussion
On-premise data gateway (personal mode) - missing data after refresh
lT-Guy,
Which specific Excel sheet does the field that you use to create the slicer come from? Is there any possibility that you can share the Excel to me? I will test it in my enviornment.
Regards,
Lydia
Hello Anonymous
Our Excel sheet has 19 columns with about 220000 rows.
The columns that are always imported contain only numbers, integer or floating point.
In the other ones there is text mostly formated "nnnnnn - xxxxxxxxxxxx" where "n" are numbers and "x" is a string.
It looks like the columns containing strings are not imported correctly, and are empty.
I can not share the original data sheet, but if it helps an additional sheet, which is used for matching postal codes to geo-data. There it looks like it is also only numerical data imported.
Best regards, gerhard
lT-Guy,
You can share dummy data to us.
Regards,
LydiaHello 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