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.
Super Usercan you provide the M code behind this query?
Im a bit new to Power bi, but where can i find the m code?
- R1k91
in pbi desktop
- transform data
- locate query
- advanced editor
that's the M code behind your query
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?
