Forum Discussion

varunsingh's avatar
varunsingh
Regular Visitor
9 years ago

Creating PowerBI Visuals and tiles

Hi,   I am a new user of PowerBI so please excuse me if you find my question to be very basic.   I am creating various tiles and reports by using fields of same table. The problem i am facing is ...
Need Help
v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
9 years ago

Hi varunsingh,

 

1. Since the past couple of days, the tiles are not getting refreshed.

 

Do you mean the Power BI Service dashboard display stale data? If that is a case, it's due to the Power BI Service itself. See: Power BI Support.

 

 

2. And another thing - Suppose i am creating many different visuals portryaing different metrics but all are using same SQL table, showuld i dulpicate the table multiple times in the same powerbi report or should i make a saperate poewerbi report for each visual.

 

We can create one query to retrieve data from SQL Server database, and create multiple visuals to display this table data, without duplicating query to create another same tables.

 

3. 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.

 

Do you mean you run the report in Power BI Service or Desktop? If in Power BI Desktop, please only import useful data from SQL Server database. Or please change Import mode to DirectQuery mode suggested by BhaveshPatel.

 

Best Regards,
Qiuyun Yu

 

varunsingh's avatar
varunsingh
Regular Visitor
9 years ago

Hi,

 

Thanks for the reply. 

 

I created the .pbix report using Import rather than direct query. How to modify the .pbix file to use direct query mode.

 

Also while using the direct query mode, how to remove duplicates (if any) from the dataset. Because i see "Remove Duplicates' feature working fine with import method but not with direct query method.

 

Thanks,

Varun