Forum Discussion
Anonymous
3 years agoNot applicable
indefinite loading in power BI report builder
Hey I need to create a paginated report based on a power bi dataset. I have two different databases from different server in my dataset. when I select the fields from the first database, the da...
bcdobbs
Community Champion
3 years agoHi Anonymous
Is your dataset running in direct query or import mode? Eg is it querying the two underlying sql database every time.
Anonymous
3 years agoNot applicable
hey,
my dataset is running in import mode and it isn't querying the sql databases every time.
in fact, my paginated report is querying the dataset in power BI service.
please read back my post, I added some details