Forum Discussion

michaeljc70's avatar
michaeljc70
Advocate II
10 years ago

Query with CTE gives error

I used SQL Server and a query that uses a CTE.  It gives me an error "Incorrent syntax near the Keyword 'WITH'. ......."if this is a common table expression......previous statement must be terminated...
Need Help
austinsense's avatar
austinsense
Impactful Individual
10 years ago

Ok, cool we're on the same page :smileyhappy:

 

We build and work with models pretty regularly that have 10 million+ rows in them so I'm curious what issues you're having - is Power BI throwing out some kind of error when you try to bring in your data?  Someone from this community could definitely help you work through this issue.

michaeljc70's avatar
michaeljc70
Advocate II
10 years ago

If you aren't writing a query, Power BI doesn't seem to support many to many relationships if you can get the data loaded.

 

Some of the tables have 100 million rows.   That is why I don't think it is realistic to not be writing quereis or at least views that break down the data further.  

 

As an example, we have around 500k accounts and then daily information about each account in a table.  Over 100 days, that is 50 million records.