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
Anonymous
Not applicable

reusing data source

Hi,

 

I am looking for feedback on other experiences.

 

Today we build data models and reports in the same .pbix and deploy them.  We are starting to use shared data source for multiple .pbix reports.  I am comfortable with this.

 

In doing this, i was curious if it is a best practice to always have a backend data source and front end report file.  Meaning, create 1 .pbix that is just the full prepped data model with all power quuery and dax completed, publish that, and then connect a 2nd file as the front end report file (even if you only plan to use the data source once).

 

Has anyone done this?  What is your experience (e.g. are the refresh times impacted good/bad when developing, does it impact the user's speed experience, etc).

1 REPLY 1
Zubair_Muhammad
Community Champion
Community Champion

@Anonymous

 

It looks a good approach to me. But I also suggest that you also post this question in the "Power BI Service" forum

Check this article by @MattAllington
https://exceleratorbi.com.au/new-power-bi-reports-golden-dataset/

 

and this one


https://powerbi.microsoft.com/fr-fr/blog/connecting-to-datasets-in-the-power-bi-service-from-desktop/

Meanwhile you can also explore "DATAFLOWS"

Here are recent articles by @reza_rad
http://radacad.com/what-are-the-use-cases-of-dataflow-for-you-in-power-bi


and

 

http://radacad.com/getting-started-with-dataflow-in-power-bi-part-2-of-dataflow-series


and a video by @ruthpozuelo

https://www.youtube.com/watch?v=bkFG8s_9sGE

 

 

 


Regards
Zubair

Please try my custom visuals

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.