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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
BInovice
Frequent Visitor

Couldn't publish to Power BI : Unable to write date to transport connection

Anyone had this issue and what are the solutions? The report has been working fine till today.

BInovice_0-1669133963821.png

 

1 ACCEPTED SOLUTION
collinq
Super User
Super User

Hi @BInovice ,

 

There could be a few different reasons for this.  THe first one that I would confirm is that your version of Power BI Desktop is recent.  It is possible that your version of Desktop is too old to "talk" to the Service anymore.

 

It could be that the Service had a random "one-off" issue and if you try to publish again it will work. (This is not likely, but is a possibility)

 

Is your data set really large and your network connection not fast enough and/or has time limit outages?  This could be the case and you may have to check with your network folks and/or run a network trace (like fiddler)




Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!
Private message me for consulting or training needs.




View solution in original post

4 REPLIES 4
BInovice
Frequent Visitor

Thanks for your help. Chasing the size and will get back once resolved.

Hi, @BInovice 

Are you connecting to an ODBC data source?

From the error message, it is possible that one of your local service applications is blocking the access to the data.

Best Regards,
Community Support Team _ Eason

collinq
Super User
Super User

Hi @BInovice ,

 

There could be a few different reasons for this.  THe first one that I would confirm is that your version of Power BI Desktop is recent.  It is possible that your version of Desktop is too old to "talk" to the Service anymore.

 

It could be that the Service had a random "one-off" issue and if you try to publish again it will work. (This is not likely, but is a possibility)

 

Is your data set really large and your network connection not fast enough and/or has time limit outages?  This could be the case and you may have to check with your network folks and/or run a network trace (like fiddler)




Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!
Private message me for consulting or training needs.




Looks like it's a combination of file sizes and network speed. I downloaded the current copy online and still can't publish it till reducing the dataset to <500 MB. Will have to play around with the archiving data and reduce data set sizes. Thank you 

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors