Forum Discussion
Refreshing data by import modus crash
Hi MarkVerwer ,
The refresh of the two connection modes of Import and Direct query is different.
Direct query:
If you are using the DirectQuery Mode, the report should query data source to get the newest data when you access the report or refresh the report
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-use-directquery
If you are using the Import Mode, it is to import data into Power BI for storage, which is equivalent to a copy or snapshot. When refreshing, go directly to Power BI to get the data without communicating with the data source.
Which Method is Better: Power bi Import vs Direct Query? - Folio3 Dynamics Blog
Solved: direct query vs. import - Microsoft Power BI Community
To use unpivot in Direct Query, you can refer to the following link:
https://community.powerbi.com/t5/Desktop/Unpivot-with-Direct-Query/m-p/909745
https://community.powerbi.com/t5/Desktop/Direct-Query-Unpivot-Table-SQL-Workaround/m-p/789784
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi MarkVerwer ,
The refresh of the two connection modes of Import and Direct query is different.
Direct query:
If you are using the DirectQuery Mode, the report should query data source to get the newest data when you access the report or refresh the report
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-use-directquery
If you are using the Import Mode, it is to import data into Power BI for storage, which is equivalent to a copy or snapshot. When refreshing, go directly to Power BI to get the data without communicating with the data source.
Which Method is Better: Power bi Import vs Direct Query? - Folio3 Dynamics Blog
Solved: direct query vs. import - Microsoft Power BI Community
To use unpivot in Direct Query, you can refer to the following link:
https://community.powerbi.com/t5/Desktop/Unpivot-with-Direct-Query/m-p/909745
https://community.powerbi.com/t5/Desktop/Direct-Query-Unpivot-Table-SQL-Workaround/m-p/789784
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks.
First i selected a table with DirectQuery and then "copied" the data to another table with;
= Table.SelectRows(ORDERS, each Date.From([DELIVERYDATE]) > Date.From("01-01-1970")) (with import)
then i could use some pivot and unpivot functions.