cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
GuidoMS
Helper I
Helper I

Question in regards of Refreshing DATA from Desktop

Hi!

 

I have a Quick Question about refreshing data in PowerBi. We have a DATASET in the online PBI service and are using PRO accounts. 

 

We used to refresh data using ODBC connection.

 

The thing is that i understand that when i download the dataset to use it locally in desktop, i should be able to refresh my report with the data in the main dataset. There are 2 "refreshes" grom what i get:

 

- Refreshing DATASET which we configured to be automatic. Everything from WEB
- Refreshing local report (connected to main dataset)

 

Is it like this? I googled this and the main focus in every article is about refreshing the DATASET, and not the local file. Maybe we are working the wrong way by downloading the dataset and it should be set from the file.

1 ACCEPTED SOLUTION
StefanoGrimaldi
Solution Sage
Solution Sage

hey, part right part wrong, the refresh on the power bi service works as you configured , the difference would be on refresing on local report, if you using a pbix file of the dataset (not connected live to the dataset but the actual pbix of it), when you refresh you are refreshing directly from the data sources, no interaction with the power bi service dataset unles you republish that pbix back to the service, but desktop file and service arent connect per se. 

View solution in original post

3 REPLIES 3
StefanoGrimaldi
Solution Sage
Solution Sage

no, like you say, if you making modification to the dataset itself you will need to work those on your pbix file anda them update it to the service, (best practice: have a main dataset managing the data model and them create live connectes report refering to thi main or sub mains datasets) if you have a scheduled refresh on power bi service this wont be affected by the changes you make on the pbix file, just when the changes and new measures etc are tested and ready, update the pbix file and sustitute the dataset pbix for the new one, this wont alter the report connect to them, unless you delete or modify something those reports use or depend on. 

StefanoGrimaldi
Solution Sage
Solution Sage

hey, part right part wrong, the refresh on the power bi service works as you configured , the difference would be on refresing on local report, if you using a pbix file of the dataset (not connected live to the dataset but the actual pbix of it), when you refresh you are refreshing directly from the data sources, no interaction with the power bi service dataset unles you republish that pbix back to the service, but desktop file and service arent connect per se. 

View solution in original post

Oh! Ok. I get it. 

 

The thing is that when i'm working on a report i need to create new meassures so i need to download the file. If i just select the (WEB) dataset when creating a new file, im limited in this aspect. What i do is create everything i need and publish to web so that the dataset updates with every modification made. At least that is how it's working for us.

 

Is there a way to refresh locally, getting data from the service and not for the source itself?

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors