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 da...
Need Help
bcdobbs's avatar
bcdobbs
Icon for Community Champion rankCommunity Champion
3 years ago

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
    3 years ago

    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