Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Iris_
Frequent Visitor

Cannot publish Power BI Desktop report to Power BI service (via replace)

Hi all,

recently I have an weird issue with Power BI publishing.


I am an admin of two workspaces:

  • DEV&TEST
  • PROD 

In DEV&TEST, I am able to publish Power BI Desktop report (4.41MB) and replace the older version of PowerBI report with the same name.

 

However, I am not able to do the same in PROD workspace. Below are the error message I got:

Sorry, you no  longer have the permission required to publish this file. Please contact your security admin for details.

Iris__0-1678105689171.png

I have tried the methods of

  • Log out and log in
  • Uploading pbix file directly in the PROD workspace, the file was successfully uploaded. But the report link is different because new objects (Report and Dataset) with the same name are created, which we want to prevent.

 

And idea how I can fix the issue?

Any feedback appreciated.

 

 

 

5 REPLIES 5
olgad
Super User
Super User

Thats odd, this happened to me always when i forgot to relink my data model from prod server to dev server that i had two reports and models with the same name in one workspace.

i highly recommend you download an ALM toolkit install it and you can access it theough external tools tab in power bi, this tool allows you to connect to two reports and see the differences between them. This way you can identify faster what is the difference bezween your prod/dev or between two prod reports in your case


DID I ANSWER YOUR QUESTION? PLEASE MARK MY POST AS A SOLUTION! APPRECIATE YOUR KUDO/LIKE!
PROUD TO BE A SUPER USER!
Best Stories, Interesting Cases: PowerBI Storytime Newsletter
Linkedin Profile: Linkedin
YouTube Channel: PowerBI Storytime
olgad
Super User
Super User

Go to your prod woekspace, click view -lineage and see the link for your data 

7048AE3D-B79E-41E1-B7E9-6F2FF7531163.jpeg


DID I ANSWER YOUR QUESTION? PLEASE MARK MY POST AS A SOLUTION! APPRECIATE YOUR KUDO/LIKE!
PROUD TO BE A SUPER USER!
Best Stories, Interesting Cases: PowerBI Storytime Newsletter
Linkedin Profile: Linkedin
YouTube Channel: PowerBI Storytime
Iris_
Frequent Visitor

Thank you Olgad.

In the view-linage the old report just stayed as before with a single data source (dataverse). Where the newly published one is with 3 data source (dataverse, 2 excel workbooks from Sharepoint). 
Not sure why it prevents overwritten...

olgad
Super User
Super User

Hi, are you using different data bases for dev and prod? New report can be created in prod only if it is a different data connection in this report rather than the one used when publishin that old prod report. Check where your old report is pointing to in terms of data and the one you are trying to publish. 
if you have Premium then better navigate through the development pipelines, then you minimize the risk of such issues happening


DID I ANSWER YOUR QUESTION? PLEASE MARK MY POST AS A SOLUTION! APPRECIATE YOUR KUDO/LIKE!
PROUD TO BE A SUPER USER!
Best Stories, Interesting Cases: PowerBI Storytime Newsletter
Linkedin Profile: Linkedin
YouTube Channel: PowerBI Storytime
Iris_
Frequent Visitor

Hi @olgad ,

thanks a lot for your reply. In DEV&TEST and PROD are exactly the same data model (resource) and report behind. And I have tested publish PROD report to PROD workspace and it works as well.

So currently,

in DEV&TEST workspace are 3 pairs of report and dataset:

  • PBI_DEV
  • PBI_TEST
  • PBI_PROD

 

in PROD workspace are 2 pair of report and dataset:

  • PBI_PROD(old): somehow broken and cannot be replced with new publishment
  • PBI_PROD

We want to prevent the need to update the report link. Because PBI_PROD(old) and PBI_PROD have different url.

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.