Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

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 loaded in the Query and also see the data in table in Data view of the desktop.


I have refreshed the data  but cant see the data.

I also checked it for the Dual mode and getting the same issue. 

But if I delete the table and again connect it as direct Query i can see the data

Frequent Visitor

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

Community Support
Community Support

Hi @muditasriv,

I'm sorry I wasn't able to reproduce your problem. The data source I used was SQL Server, first I used it with DQ mode to connect, and created some visuals. after switching its mode to Import, the data of visuals was still displayed properly. Later I added another DQ data source and changed it to mixed model, the data of the visuals was also displayed normally as shown in the figure below.

yingyinr_0-1630904249296.pngWhat data source are you using? What kind of visual did you create? Table, Matrix or other visual? Are all the visuals not displayed properly after switching from DQ to Import mode? If you delete these visuals and recreate them, will the data be displayed properly?

Best Regards

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors