"Publishing is complete, However, we couldn't refresh your dataset" AND Other issues

[Anonymous]

Hello everyone! 

I created a PBIX file that will act as a data set for several reports (so no visuals) and I have been successful in connecting one report to it. However, this week, I started getting several errors when I try to publish the file.

There are two main changes that I did on this report: I have added new measures and calculated columns, and I also recently switched all the Excel files we use on the queries from a One Drive sharepoint link (my-sharepoint.com) to a Group Sharepoint link.

I have a feeling the file is corrupted... but I am hoping to not have to recreate the whole file. HELP!

Here are the errors I have been getting. 

1. I am unable to add a new page (plus sign is not responding).
2. When I try to create a visual, it gives me "An Error occured while rendering report" with no other details. I always click Report this Issue everytime I get it.
3. When I publish, I get the "Publishing is Complete. However, we couldn;t refresh your dataset. Please manually refresh your dataset in the service or schedule refresh".
4. When I try to refresh it on the PBI Service, nothing happens. 
5. I tried to create a copy of a previous version of the report and publish it, thinking that whatever change I did caused the issue, but then got a different error message: "An error occured while attempting to publish the file. Publishing failed for an unknown reason"
6. I also tried to publish the same report to a different workspace (doubtful about this but I had to try)
7. Also cleared clache, closed the desktop and reopened, etc. 

Once again, I am avoiding having to recreate the file, and I don't want to delete whatever instance I have that I have to manually refresh by publishing via the desktop, but there's just too many errors on this file. THank you so much for your help!

[jsmn]

I was able to solve this by creating a new blank PBIX file of the same name and uploading it (overwriting the existing dataset). Then open up the original pbix and reupload (overwriting your blank one). This approach retains all of the lineage reports and worked for me. 

My hypothesis is it was a connection issue for me, and this allows everything on the server to completely reset based on what's in your pbix file. 

[Greg_Deckler · Accepted solution]

@Anonymous You could check the Issues forum here:

https://community.powerbi.com/t5/Issues/idb-p/Issues

And if it is not there, then you could post it.

If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".