Forum Discussion
Problem refreshing Power bi
which option did you choose when downloading?
in order to see the power query you need to downalod the report and the semantic model not the live query report only.
if you chose "a copy of the report and data" and you get a live connected report it means semantic model (and M query) is somewherelse.
you can verify if your report was originally a live connected one looking to the lineage view in power bi service.
So, since i didn't create the report its not stored locally on my computer, its on his computer which is gone.
So im assuming the way i get it into power bi desktop is downloading a editable file of the report and loading that into the desktop version.
However after doing this and going into transform data no querys are shown?
Am i doing wrong?
are you sure you haven't queries in it?
in power query, table = query
Yeah, like o load the file i downloaded and press "transform data", up comes "A directquery connection is required" so i press add a local model.
Then its shown like this.which option did you choose when downloading?
in order to see the power query you need to downalod the report and the semantic model not the live query report only.
if you chose "a copy of the report and data" and you get a live connected report it means semantic model (and M query) is somewherelse.
you can verify if your report was originally a live connected one looking to the lineage view in power bi service.
Thanks a lot guys! it now works and updates as intened 🙂 Could not have done it without you ❤️