Forum Discussion
New DAX table forces Mixed Mode
I have a report with a Fact table and several dimensions, all of which are in DirectQuery mode. So the report Storage Mode is DirectQuery. However, as soon as I add a new table using DAX GENERATESERI...
Hi SamTrexler,
what is your data source?
I just tried to create a similar case as yours, with direct query to a SQL Server. Instead of using DAX and GENERATESERIES, I constructed the necessary values in a SQL query. It seems to be working.
cheers,
s
Hi, sturlaws , thanks for your reply. My data source is also SQL Server.
I hadn't considered querying the numbers from SQL Server - seems like a lot of unnecessary overhead to go out and get such constants across the Enterprise Gateway, etc. But I'll give it a try and check it out with SQL Profiler to see what the impact is.
Thanks for the suggestion.