Forum Discussion

karo's avatar
karo
Icon for Advocate V rankAdvocate V
5 years ago

How to remove live connection from .pbix file ?

 Hi,   How we can remove live connection from .pbix file?  I do not want to recreate entire report layout, but I need to change storage mode what is in use.  Is it even possible? Please help.   ...
Need Help
abdul_Kochi's avatar
abdul_Kochi
Icon for Advocate I rankAdvocate I
5 years ago

Hi,

1. If you are trying to change the same file type then you can follow the same.

    a) File-->Options and settings-->Data source settings

    b) Change Data source.-->select new source file

 

 

If you want to change the source different file type ( for eg: instead of excel file, an sql data needs to use)

1. Get Data-->select new source file

2. Go to advanced edit query-->Advanced Editor and Copy the M code

3. Paste this code to old file source file.

 

 

 

 

 

 

 

Regards,

Abdul