How many rows do you have in your dataset ? Have your tried to change your model to a dimensional one ?
I had a problem like this, I solved it normalizing the fact table.
We have 20 million rows of phone data and using DAX Studio I can see that the DateTime fields are the main issue but we need to be able to display the Call Date.
Yes I could go down to seconds in the dimension and that might solve the issue - I may try that!
The model is already dimensional but I guess it's just the amount and type of data that we have.
We can't afford Power BI Pro but limiting the service to 1 GB seems slightly restrictive for some users unfortunately.
Anyway, it's a great product so I can't complain too much.
Hi @MattieG72MP ,
I fear the same thing happening to me.
Since you mentioned,I wanted to know the following:
1. The 1 GB limit applies only to the dataset or (dataset+PBI visuals) combined?
2. Typically what are the data dimensions (in terms of rows/columns/data type) at which we start to hit limits?
It would be of great help to me.