Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello everybody,I have an issue about the refreshing of a dataset, and I'm not sure where I'm doing something wrong.
This is what I did:
Am I doing something wrong, or did I not undersand correctly how it works? I imported more rows, so it should update on Power BI, or it shouldn't have to?
My goal is to have the dataset imported from the SQL server automatically updated, once a day, in Power BI.
Any help is really appreciated, many thanks.
EDIT: I just noticed that a new version of the gateway has been released yesterday. I am going to update it and hope it solves the problem.
Solved! Go to Solution.
@MaxItaly "I save the file locally (I don't re-publish the pbix file)" -> This is your problem. The Service is a copy of the PBIX file. The Service is refreshing against your query where you specify 1000, not 2000. If you want theunderlying query to change in the Service, you need to publish the PBIX again and replace it.
To say it another way. A PBIX file needs to be published each time if you change something in the model/report level.
The gateway will refresh only the data based on what you have defined and published.
@MaxItaly "I save the file locally (I don't re-publish the pbix file)" -> This is your problem. The Service is a copy of the PBIX file. The Service is refreshing against your query where you specify 1000, not 2000. If you want theunderlying query to change in the Service, you need to publish the PBIX again and replace it.
To say it another way. A PBIX file needs to be published each time if you change something in the model/report level.
The gateway will refresh only the data based on what you have defined and published.
Ah, now I understand, thanks you very much for the clarification!
Since I have very large databases, I wanted to test some features with less data and I was afraid the email subscription wasn't working. But thanks to your precisation, now i know that everything will work fine when I'll import all data.
Thank you very much again!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.