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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
CharlotteB
Helper II
Helper II

Error Help - Can't publish Power BI Desktop file. Looks like that we're unable to access the dataset

Hello,

I'm wondering if anyone can help me - I gave my client a bunch of reports all connected to one dataset. He wants to upload all of these files into HIS workspace. He uploaded the dataset successfully, and he changed the connection string by changing the parameters in the dataset settings (I made it so the Server Name and Database Name are parameters so you can change the connection string in the workspace without opening the report). The problem is when he tries to upload individual reports - he gets this error: 

 

"Can't publish Power BI Desktop fileLooks like we're unable to access the datasetPlease contact the owner of the dataset."

 

It seems like he needs to open each report and repoint it to the PowerBi Dataset he successfully uploaded, and then publish it himself. Does anyone know why he can't simply upload the reports from the workspace? Why isn't it finding the dataset that he successfully uploaded? Is the only way to really open all of the individual reports and report them that way?

 

Thanks in advance!

1 ACCEPTED SOLUTION
v-zhangti
Community Support
Community Support

Hi, @CharlotteB 

 

Based on the error message you provided, it seems like the reports are still pointing to the original dataset, rather than the one your client uploaded. This could be because the connection string was not updated in the report files themselves.

 

To resolve this issue, your client will need to open each report and update the connection string to point to the new dataset. This can be done by going to the "Edit Queries" menu, selecting "Data source settings", and updating the connection string there.

 

Alternatively, your client could try creating a new report in the workspace and connecting it to the new dataset. This should create a new report that is properly connected to the dataset, which can then be published to the workspace. However, this may not be a feasible solution if there are many reports that need to be updated.

https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-upload-desktop-files#republish-or-... 

 

Best Regards,

Community Support Team _Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

View solution in original post

2 REPLIES 2
v-zhangti
Community Support
Community Support

Hi, @CharlotteB 

 

Based on the error message you provided, it seems like the reports are still pointing to the original dataset, rather than the one your client uploaded. This could be because the connection string was not updated in the report files themselves.

 

To resolve this issue, your client will need to open each report and update the connection string to point to the new dataset. This can be done by going to the "Edit Queries" menu, selecting "Data source settings", and updating the connection string there.

 

Alternatively, your client could try creating a new report in the workspace and connecting it to the new dataset. This should create a new report that is properly connected to the dataset, which can then be published to the workspace. However, this may not be a feasible solution if there are many reports that need to be updated.

https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-upload-desktop-files#republish-or-... 

 

Best Regards,

Community Support Team _Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

I have the same problem actually if anyone can help me, this is the error message I'm having

alexasma_0-1716465470742.png

 

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors