Forum Discussion
Online Connection String Changes
I am having issues where i publish a report that works just fine in desktop and made sure the connection string is correct for mapping to a network driver.
Desktop Connection String:
\\"network fully qualified"\dept02\powerbi\file.xlsx
but the online string is showing duplicate "\"
Online Connection String:
\\\\"network fully qualified"\\dept02\\powerbi\\file.xlsx
What would cause this string when publishing online to do the duplicate which then doesnt allow me to schedule the report because of an unknown string?
Hi trentchecketts1 ,
The product team are working on fixing this issue now. (ICM#: 256366460)
Please be patient and I'll post here if there is any update.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
5 Replies
Hi trentchecketts1 ,
I think you are using Power BI Service, not Power BI Report Server. Right?
For Power BI Service, it is needed to use a gateway to refresh on-premises data sources.
Here is an example. This is the same issue you meet, right?
If so, it is needed to click "Add to gateway" to add the data source into your on-premise gateway like so:
After the data source is connecting successfully, it will automatically return to the previous page. Then, map to the data source you configured and apply. And you can set scheduled refresh now.
Here are some documents for reference:
What is an on-premises data gateway? | Microsoft Docs;
Install an on-premises data gateway | Microsoft Docs;
Use the on-premises data gateway app | Microsoft Docs;
Configure scheduled refresh - Power BI | Microsoft Docs;
Manage your data source - Import/scheduled refresh - Power BI | Microsoft Docs.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
We already have gateways setup which is what the desktop connection string should be matching when published.
IF im using a sql server connection example SQL-test123-ao.ad.company.com then the connection string in desktop stays the same.
But when i publish (ONLY WHEN NETWORK) does it change the string.
\\Network drive\powerbi\file
changes to
\\\\network drive\\powerbi\\file
which duplicates all the "\"
I see in yours that it has 4 2 2 as well. is that just going to be the result when using a network is additional "\" ?
Hi trentchecketts1,
I can reproduce the issue and have reported it internally. Let's be patient.
And in addition, does this affect your normal use? Any screenshots without sensitive information?
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi trentchecketts1 ,
The product team are working on fixing this issue now. (ICM#: 256366460)
Please be patient and I'll post here if there is any update.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
