I have created a DataSet because I have a set of data that I know i will need to use a few times potentially in other reports.
The issues i find is that when i import the dataset it’s a direct query which really slows everything down. This data is only updated once a week so i don’t need direct query. Am i able to change the dataset so that it imports the data?
In the bottom right corner of my screen it says “Storage Mode: Direct Query”.