Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet 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
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.
Solved! Go to Solution.
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.
Proud to be a Super User!
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.
Proud to be a Super User!
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.
Proud to be a Super User!
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?
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
92 | |
86 | |
85 | |
66 | |
49 |
User | Count |
---|---|
140 | |
113 | |
104 | |
64 | |
60 |