cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PaulMGNT
Frequent Visitor

Delete all data and connection from PBI desktop model

Hi,

 

I would like to know the proper way to delete all data and connection to a power BI desktop file.

 

I deleted all the tables and PBI tell me that I have no data source connected to the file, fine. But when I want to make a direct connection to an online PBI model, I have an error message saying that my file contains data from an other source so I cannot do the connection the right way.

 

Do you have any idea why and how I can properly delete all data source / data of my file ?

 

Many thanks,

Paul

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@PaulMGNT , Are you trying a Live connection? Better try in a new file. Or open power query(Transform Data under home Tab) and make sure there is no table of error table left



!! Microsoft Fabric !!
Microsoft Power BI Learning Resources, 2023 !!
Learn Power BI - Full Course with Dec-2022, with Window, Index, Offset, 100+ Topics !!
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!

View solution in original post

3 REPLIES 3
amitchandak
Super User
Super User

@PaulMGNT , Are you trying a Live connection? Better try in a new file. Or open power query(Transform Data under home Tab) and make sure there is no table of error table left



!! Microsoft Fabric !!
Microsoft Power BI Learning Resources, 2023 !!
Learn Power BI - Full Course with Dec-2022, with Window, Index, Offset, 100+ Topics !!
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!

Hi @amitchandak , thanks a lot. Indeed I had two parameters left in power query....

 

Paul

amitchandak
Super User
Super User

@PaulMGNT , Are you trying a Live connection? Better try in a new file. Or open power query(Transform Data under home Tab) and make sure there is no table of error table left



!! Microsoft Fabric !!
Microsoft Power BI Learning Resources, 2023 !!
Learn Power BI - Full Course with Dec-2022, with Window, Index, Offset, 100+ Topics !!
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!

Helpful resources

Announcements
May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Submit your Data Story

Data Stories Gallery

Share your Data Story with the Community in the Data Stories Gallery.

Top Solution Authors