Showing results for 
Search instead for 
Did you mean: 
TJ-9000 Frequent Visitor
Frequent Visitor

Format Dataset or Query



I have a number of reports for different audiences that use the same dataset. I now basically copy all the query steps to each of my .pbix files and let them exist independently. As you might imagine this becomes maintainance heavy whenever I makey any changes to it because I want them to remain in sync, which now requires me to go into all files in order to say add a column. Also this of course duplicates the data on the Power BI server. 


My attemption fixes so far was to try and connect to an existing dataset using the Power BI Service, but I seem to lose the ability to change the format of the columns in dataset, for example I can't seem to add thousand separator. Secondly, I tried to set the correct format in the query process, which i also wasn't able to do, but maybe I missed something there. I figured maybe with dataflows it could be done, but don't think that solves it either as the connections seems the same as the way you connect to a dataset. 



Any suggestions?

Community Support Team
Community Support Team

Re: Format Dataset or Query

Hi @TJ-9000

With a pro license, you could create an App worksapce in Power BI Service,

Add users (also need pro licenses) as members of this App worksapce with edit permission,

Create the original report (connect and transform data) with Power BI Desktop, publish the pbix to the App worksapce in Power BI Service,

Users connect to Power bi dataset with Power BI Desktop, then they can create their own reports.



Collaborate in your Power BI app workspace

Connect to datasets in the Power BI service from Power BI Desktop


Best Regards




TJ-9000 Frequent Visitor
Frequent Visitor

Re: Format Dataset or Query

Hi Maggia @v-juanli-msft


I have my Power BI files uploaded to an App Workspace, and I've tried to do exactly what you suggest. The problem I run into is that when I connect to this dataset I cannot change the formatting e.g. have numbers displayed with a thousand seperator. The 'modeling' portion of Power BI desktop is greyed out when connecting directly to a dataset. 




Helpful resources

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 266 members 2,999 guests
Please welcome our newest community members: