Forum Discussion

BossCo's avatar
BossCo
Icon for Helper II rankHelper II
5 years ago

Unmatched values as blank

Hi everybody, I have a big strange problem...   Usually, when I link my fact table with my dimension table, usually not all values match. This is normal. And usually, when I create a visual with m...
Need Help
BossCo's avatar
BossCo
Icon for Helper II rankHelper II
5 years ago

I will soon, but in the meantime I discovered something new: switching from "direct query" to "import" it suddenly works, while with direct query it doesn't so there must be a problem in the connection.

 

With the dimension table located in my sql server I got the empty dimension both with direct query and with import mode, while with the dimension table located on my customer's sql server it works only with the import mode.

I'll share sample data asap,

 

thanks