Forum Discussion

joglidden's avatar
joglidden
Icon for Advocate III rankAdvocate III
10 years ago

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. 

 

 

Need Help
Tips and Tricks

14 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    10 years ago

    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?

    • joglidden's avatar
      joglidden
      Icon for Advocate III rankAdvocate III
      10 years ago

      Anonymous 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. 

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        10 years ago

        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)

  • adrianbravo's avatar
    adrianbravo
    Icon for Helper I rankHelper I
    10 years ago

    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's avatar
      joglidden
      Icon for Advocate III rankAdvocate III
      10 years ago

      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's avatar
        adrianbravo
        Icon for Helper I rankHelper I
        10 years ago

        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.