indefinite loading in power BI report builder

[Anonymous]

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

[bcdobbs]

Hi @Anonymous 

Is your dataset running in direct query or import mode? Eg is it querying the two underlying sql database every time.

[Anonymous]

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