Forum Discussion

alm5084's avatar
alm5084
Helper II
9 years ago

Power BI Desktop Loads Data forever

I'm trying to import data into Power BI desktop from an analysis services data source on premise. We don't have a data gateway set up, so the data needs to be published with the reports. It takes FOR...
Need Help
v-caliao-msft's avatar
v-caliao-msft
Microsoft Employee
9 years ago

alm5084,

 

If dataset is large and you've used import you may have performance issue plus longer times for data refresh. DirectQuery would take away the need of data refresh but that means there maybe bit of delay in getting data for visuals as queries would be sent to on-premise data source. For example when you apply a filter queries would be sent to on-premise data source.

 

In your scenario, Please try to use DirectQuery mode to get data in your Power BI report and check if this issue persists or not.

 

Regards,

Charlie Liao

Sunkari's avatar
Sunkari
Responsive Resident
9 years ago

I don't think there will be a huge performance difference between Power BI and Power Pivot. If it working with Power Pivot in 5 mins, will work with Power BI as well. 

 

We will see performance issue in a case of huge data, to avoid this. Use direct query and have gateway in place, which might solve your problem