topic Re: indefinite loading in power BI report builder in Report Server

indefinite loading in power BI report builder

Anonymous — Thu, 11 May 2023 09:07:29 GMT

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

Re: indefinite loading in power BI report builder

bcdobbs — Thu, 04 May 2023 18:39:32 GMT

Hi Anonymous

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

Re: indefinite loading in power BI report builder

Anonymous — Thu, 11 May 2023 09:14:11 GMT

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