cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
madzgalj_darko
Frequent Visitor

Syncing Dataset in Power BI Desktop and BI Service?

Hello everyone,
I would need help about syncing PBI Desktop and PBI Service. To be more specific, if I publish a dataset and report from PBI Desktop to PBI Service, for example later I would need to download and edit that dataset(to add some rows/columns and/or measure) from Service to Desktop but for example, on another PC or another account(which has permission to edit workspace).
I was reading multiple articles, couldn't really find anything similar. Basically I want to download and edit dataset on any pc with my power bi account. This is really crucial for my management. To add my dataset is set to large dataset storage format. It has few million columns.
Thank you in advance! 

1 ACCEPTED SOLUTION

Hi @madzgalj_darko 

 

I would recommend always working from the PBIX file to make changes and then use the external tool ALM toolkit to then publish the changes.

 

I would suggest storing your PBIX files in OneDrive/SharePoint, which will allow you to get them from any PC.

 

There are instances where you might not be able to download the PBIX file from the Power BI Service. So having the original PBIX file is critical.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

View solution in original post

3 REPLIES 3
GilbertQ
Super User
Super User

Hi @madzgalj_darko 

 

If you have a lot of columns and you want to only add the new columns you need to use Power BI Premium Per User or Power BI Premium where you can use the ALM Toolkit to be able to only add the columns that you want.

 

Currently you cannot add columns or measures in the Power BI Service today.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Hello @GilbertQ,
Thank you for quick answer. I have Premium Per User. Acctualy would you know any other option besides this external tool?
For example downloading dataset somehow or editing live in Power Service? It might be that my PC is not with me all the time and I want to log in on another PC download, edit, and publish dataset. 
Thank you! 

Hi @madzgalj_darko 

 

I would recommend always working from the PBIX file to make changes and then use the external tool ALM toolkit to then publish the changes.

 

I would suggest storing your PBIX files in OneDrive/SharePoint, which will allow you to get them from any PC.

 

There are instances where you might not be able to download the PBIX file from the Power BI Service. So having the original PBIX file is critical.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

BizApps LATAM 2023

Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

Power Platform Bootcamp

Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.

Top Solution Authors
Top Kudoed Authors