Forum Discussion
Refresh Failed
Sujit_Thakur - Go to File | Options & Settings | Options and in Data Load, turn off auto time intelligence or whatever the setting is called. Here it is, uncheck that: Also, maybe under CURRENT FILE | Data Load as well since you have an existing file. The refresh your data.
Dear Greg_Deckler sir ,
My Pbix is 4.5MB .
and thanks for your so prompt response and kind help🙌
Thank you very much!!
I am happy to tell you that i solved it !!!!!!
I just reduced some calculated columns , used star-type model and removed unused rows .
Thank you so much again !!!
Regards ,
Sujit Thakur
Sujit_Thakur - Well, Pro has a limit of 1 GB dataset size. I suppose it depends on how many files, but doesn't seem like you should be hitting that limit. One thing that I have found that blows up data models are date tables. Especially if you have the automatic date hierarchy stuff turned on.
Yes Greg_Deckler sir ,
I do have Some date columns in my data table .And they also have automatically generated in date hierarchy
So should I delete those hierarchy and try ?
Sujit_Thakur - Go to File | Options & Settings | Options and in Data Load, turn off auto time intelligence or whatever the setting is called. Here it is, uncheck that: Also, maybe under CURRENT FILE | Data Load as well since you have an existing file. The refresh your data.
Dear Greg_Deckler
I unchecked that box
But still it failed .😓
Please suggest further what should I do .
Request to help .
Regards
Thakur sujit
Sujit_Thakur - How big is your PBIX file?