Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Gyan
Frequent Visitor

Use one PBI file with direct query as source of many report.

Hi,

I'm looking for some suggestions with the logic on below thought-

 

In the case of import mode, I usually use one PBI file to create the model, publish it and then use it as a live/import connection for other related reports.

Is it wise to follow the same practice if I have a model built on using only direct queries due to high data volume?

 

I mean create a model using a Direct query publish it and then use is a live connection for the rest of the related reports (2-4 report using that data set)

 

Thank you for looking into this.

2 REPLIES 2
Gyan
Frequent Visitor

Hi @amitchandak ,

 

Yes, I agree that we can do it. I'm seeking some suggestions from a Performance viewpoint. 

 

In a normal case, if I have a file with a direct query, it will hit to data source let’s say SQL every time a user does any interaction on the report. 

But in case using a single model file created with a direct query and using it as a source for a few other reports will make all those queries go through one single PBI report.

furthermore first main model file will extract data from SQL then it will pass along that data to other connected reports that will consume time.

 

Also if there are 100 + users using all those related reports and all backed quires going through a single file which seems to be challenging from the viewpoint of limitation on max 20 queries can be executed a single point of time. The rest of the queries will be queued which will reduce the performance.

 

amitchandak
Super User
Super User

@Gyan , You can create a direct query dataset and you use that as live dataset in new report

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Power BI Header Change

Power BI Header Update

Read about the exciting updates for the Power BI forum.