Use published dataset in datamart

[Deckard_X42]

Hello everyone, 

My organisation use a single published dataset as a base for most of the reports. 

I would love to be able to use this published dataset as a datasource then use the modelling functionalities to combine it with other data sources and create a ready-to-use datamart for other users to base their report on. 

Unfortunatly, no one have acess to the underlaying SQL server and it seems that Power Query cannot use a published dataset as a source. 

Does anyone know a way to do that? 

Thank you in advance!

[otravers]

I don't think Microsoft intends datamarts to be located downstream of datasets, the intent is the inverse pattern. You'd have to 1) empty out your current's dataset ETL and migrate it to dataflows, 2) use said dataflows as the sources for your datamart, 3) recreate your DAX measures in the datamart's dataset, and 4) promote that new dataset as the basis for user reporting.

But do be able to do that you need access to the current dataset's data sources. How can you even refresh your existing dataset if "no one have access to the underlaying SQL server"?