Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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's avatar
    bcdobbs
    Icon for Community Champion rankCommunity Champion

    Hi Anonymous 

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

    • Anonymous's avatar
      Anonymous
      Not 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