Forum Discussion
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 data is displayed well.
however when i want to include another fields from the second database in my report, there, where I find the indefinite loading problem.
In the data model I have a many to many relationship between table x of the first database and table y of the second database. How can I solve this indefinite loading problem ? I created the bridge table however I still have the same problem of indefinite loading
please help me
thank you a lots
2 Replies
- bcdobbs
Community Champion
Hi Anonymous
Is your dataset running in direct query or import mode? Eg is it querying the two underlying sql database every time.
- AnonymousNot 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