Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Errors: 1. This step results in a query that is not supported in Direct Query mode. Switch all tables to Import mode

Solution: Don't change the data type while loading(tranforming )data. First load the data using Direct Query option without transforming and then do the following to change data type of your data.

 

Go to "Data Modelling tab"-> "Select or click on the Query or table you loaded using Direct Query-> Select the column that we need to change the Data type and format-> then go to an option in topmost corner under Modelling tab to change the column Data type and format.

 

2. This table uses DirectQuery and cannot be shown

Solution:

If we go to Data modelling tab in the Left corner below chart tab to change any column format, It will not show the table as we used Direct Query to load data from the database. It shows as" This table uses DirectQuery and cannot be shown". 

 

If we need to change the format of the column that is loaded using Direct Query, We need to go to "Data Modelling tab"-> "Select or click on the Query or table you loaded using Direct Query-> Select the column that we need to change the Data type and format-> then go to an option in topmost corner under Modelling tab to change the column Data type and format.

CARAYOZ's avatar
CARAYOZ
New Member
3 years ago

Hi, 

 

Do you know how to keep the format unchanged when export the data table to excel? 

 

Under column tools, Data type is "Date", Format is "Short Date". 

The Date in PowerBI desktop is shown like '2/01/2023',

BUT when I export, it become '2/01/2023 12:00:00 AM' in EXCEL