cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
joglidden Member
Member

Will not publish...

So here is my particular publishing issue...

 

I make changes to a PBI report in desktop and publish it, and it just spins.... and spins.... and after half an hour I hit 'cancel'. 

The only way I can get it to publish is to go to the service and delete the report and the dataset, then go back to desktop and publish it again. Then it works!

 

The problem is, that I have to rebuild my dashboard again, which I'm getting tired of doing. 

 

My apologies if this issue has been solved elsewhere. If so, please someone link me the solution. 

 

 

14 REPLIES 14
Super User
Super User

Re: Will not publish...

@joglidden Have you always had this issue, or is it recent? (Can you tie the behavior to a recent update) What are you using as a datasource/connection and how large is it?


Near SE WI? Join our PUG Milwaukee Brew City PUG
adrianbravo Regular Visitor
Regular Visitor

Re: Will not publish...

Hi,

I had the same issue, and i found a way to publish, i created a group and inside the group i publish my dataset, and when i want to re-publish i dont have problem.

I know that is it not a solution but maybe for you it is.

joglidden Member
Member

Re: Will not publish...

@Seth_C_Bauer I have the most recent version of PBI desktop. 

Datasources is a 2012 SQL Server that I connect to remotely via VPN. It is solid, I've checked.

I am running the on-premises data gateway on my local machine, I've checked it, and it's running just fine. I installed it last week from the most recent available download. 

The data set is tiny. We're talking K, not MB. 

 

joglidden Member
Member

Re: Will not publish...

@adrianbravo Please give me a little more detail... How do you publish a dataset only? And you publish the dataset in one group, and the report in another group? This might be a workable hack. 

adrianbravo Regular Visitor
Regular Visitor

Re: Will not publish...

I tested 2 way :

1) I published within  myworkspace and i got the error.

2) I published within a group and it work.

I don't know why, but it work for me.

joglidden Member
Member

Re: Will not publish...

@adrianbravo Got it. So, I have been publishing in a Group I created, and it works sometimes, but after a day or two, it stops publishing altogether, and I have to go back to deleting everything and re-publishing from scratch. Are you running an on-premesis gateway? Can you tell me what your data source is?

Super User
Super User

Re: Will not publish...

@joglidden Have you created the data source in the gateway? I'm assuming you are the admin so there shouldn't be a need to add yourself as a approved user, but you may need to create the data source (SQL) in the on-premises data gateway prior to publish. (This is done in the Power BI Service)


Near SE WI? Join our PUG Milwaukee Brew City PUG
joglidden Member
Member

Re: Will not publish...

@Seth_C_Bauer Good questions, yes, and yes. I have published this several times already, so it has worked... it just stops working and won't re-publish until I delete it on the service side.Capture.JPGCapture2.JPG  

Super User
Super User

Re: Will not publish...

@joglidden Whatever action you choose. be sure to send a frown via the desktop, this shouldn't be happening.


Near SE WI? Join our PUG Milwaukee Brew City PUG

Helpful resources

Announcements
Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 122 members 1,632 guests