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

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
jlie
Advocate I
Advocate I

Use a Published PowerBI Dataset as Datasource for other reports

Hey there,

 

I stumpled upon a very simple idea, which I can't seem to realize with the current features of Power BI. Please help me out here, if this is in any way doable!

 

My ultimate goal is to build a lean and simple "reporting OLAP Cube". I frequently integrate multple datasources (mostly MySQL, Salesforce, Google Analytics, Zendesk, Local Files and the likes) into my reports, and some of my reports use the same sources and sometimes even the exact same queries over and over again. However, it is not feasible to put everything into one gigantic "master report/dataset", because it would make the queries incredibly slow. It would be very effective (especially maintenance-wise) to encapsulate some logically connected reusable queries into one dataset, publish it to the web and then query this dataset as some sort of OLAP Cube.

 

I already tried the "PowerBI Live Service"-Feature, but it is not feasible, because if I connect a PBIX to a "Live Dataset" I can not add other data queries which renders the whole concept completely unusable.

 

Is there any way how I could achieve my goal?

1 REPLY 1
Seth_C_Bauer
Community Champion
Community Champion

@jlie My first thought for this would be to build the "Base" dataset as a Power BI Template file in the Desktop. Then you have a starting point for every new dataset you create saving you a bunch of time. This doesn't solve a single deployed model, but it would solve the duplication of efforts aspect.

There is no way to achieve a "starter" dataset in the Service that you would expand upon from there.


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.