Forum Discussion
Data not visible in report page after changing data source from DirectQuery to Import/Dual mode
I had all my tables in DirectQuery mode and I changed one table from DirectQuery to Import mode. After doing this i cant see any data from that table in the report page. I can see the rows are load...
I am using Azure sql Database. I am trying to change my Dim tables to import/dual mode. I was using them to create a filter. so when i change the storage type to import/dual the filter is coming as blank. Although i can see the data is being loaded (by msgs like 12 rows added and in the edit query i can see the data). Yet in my filter or if any other table i create, i cant see the data.
Yes if i delete and connect again to the direct query it is working. So that is the work around i am using
This is not happening for all the queries. I am facing problem for 2 queries out of 5