Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Flushing data from PBIX report file

Hi Experts.

 

I am trying to flush data out of an existing report.

The report is sourcing the data from an another pbix file which we call it as cube.

 

I tried File>>Export>>As template but the template file size is same as the original file and when I open the template the data still displayed.

 

Wondering if there is a way I can flush out the data from pbix file which sources the data from another pbix file.

4 Replies

  • Anonymous , Using DAX studio you can download.

    You can also try power Automate visual

    • Anonymous's avatar
      Anonymous
      Not applicable

      Thanks heaps amitchandak 

       

      We do have restrictions on the use of third party tools like DAX Studio.

       

      I would appreciate if you could please provide some links where the detailed steps are outlined, both for DAX studio and the Power Automate visual. I would try seek permission from my IT admin to get the DAX Studio installed.

       

      My learning continues..

       

      Thanks in advance.

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Anonymous ,

     

    What are the data sources of the two PBIX files? Check if this article below can solve your problem.

    How To Change Data Source Of Existing Report In Power BI

     

    Best Regards,
    Gao

    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly -- How to provide sample data

  • Anonymous's avatar
    Anonymous
    Not applicable

    Thanks guys for your help.

    Infact my pbix files were using the live connection to the other pbix file as the data source.

    There is no data in the report but as soon as I open the report the data gets refreshed.