Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Is there a way in Power BI desktop to remove an existing table within a dataset, and re-add the same tableto that dataset? I was told by our company's IS group that this could be done in order to resolve database connection access issue, and that it would NOT disturb the applied steps already tied to that table.
Solved! Go to Solution.
@elliobr , for the database connection issue
go to Home Table-> Data Transformation -> Data Source credential -> Clear permission and refresh one table
You need to add credentials again
Deleting a table will delete custom columns and relationships
Thanks. So, it sounds like there's no way to successfully delete a table in Power Query and reattach without upsetting any of the Table query Applied Steps. I didn't think so either, but I was told by my IS group that this could be done in the dataset. Again, thanks.
@elliobr , for the database connection issue
go to Home Table-> Data Transformation -> Data Source credential -> Clear permission and refresh one table
You need to add credentials again
Deleting a table will delete custom columns and relationships
After rereading your response, perhaps you're simply suggesting how to fix the connection issue w/o deleting tables. Please confirm.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
104 | |
70 | |
67 | |
55 | |
41 |
User | Count |
---|---|
156 | |
83 | |
66 | |
64 | |
61 |