Forum Discussion
Creating PowerBI Visuals and tiles
Hi, welcome to the forums!
Things you could try:
- remove unused columns in the original sql query (not PowerBI query editor)
- aggregate rows: for example if you always calculate sum of certain columns, try calculating "sum()" with "group by" in sql query.
- if you only use portion of your data, for example, always filter and show only recent year, do this filtering in sql,
If you post specific details - then you might get more specific suggestions.
Regarding your second question, why do you need to duplicate the table? Just use the same table in each different visual.
Hi,
To be more specefic, i have a table which contains more than a billion records. And this table has many columns. Now in powerbi i created the sql connection to this table. I limited the columns which i need for my reports to 4.
Now lets say the columns are timestamp, A, B I have to display reports like trend of A, total of A, trend of B, total of B and few more details like this.
When i creted the report that time there was less data in the table so it was working fine. Now the data is more in the table and the refresh of the datasets is failing and i am not able to load this much data in my PC as my PC has limited ram.
How to solve this?
Thanks,
Varun
Hi Varun,
As I suggested, Direct Query would be more appropriate option for your case as you have bottlenecks in terms of limited RAM and there is currently no alternate turnaround for the data compression in powerbi.
Given that you do not require complex and advanced calculations in your data model.
Is there any specific reasons not choosing direct query option?
