Forum Discussion

Nadim1's avatar
Nadim1
Frequent Visitor
3 years ago
Solved

Modify Query for Published Power BI Report

Hi all,   I'm wondering how I might be able to modify the query / data source for a published Power BI Report. I made a report in Power BI Desktop, and then to share it with colleagues and have it ...
Need Help
  • GilbertQ's avatar
    GilbertQ
    3 years ago

    Hi Nadim1 

     

    Yes that is one way to do it, when you overwrite the dataset all the reports will remain the same without any changes or modifications.

     

    You could also look at using dataflows if you want to update the query as long as there are no columns added.

GilbertQ's avatar
GilbertQ
Super User
1 year ago

Hi LauraH 

 

When you download the power BI file, you should then be able to open it up in power bi desktop and view the relationships and measures that were in the model once that is done, you can then publish it back up and overwrite the existing model, which will then have your new changes.

LauraH's avatar
LauraH
Frequent Visitor
1 year ago

Thank you GilbertQ, I know that is the theory but in practice I'm only able to see the relationship tables not able to see the tables themselves. 

Thanks

  • GilbertQ's avatar
    GilbertQ
    Super User
    1 year ago

    Hi LauraH 

     

    Can you make sure that you have downloaded the Power BI model and data?

    • LauraH's avatar
      LauraH
      Frequent Visitor
      1 year ago

      ah, maybe here is the problem! When I go to file>download this file the option 'a copy of your report and data' is blanked out, the only option is a copy of your report with live connection to data online. 

      Any suggestions?