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,

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

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

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