Hi All,
I have build a report using a Composite Model with 3 data sources, 2 csv files and 1 Direct Query from Oracle SQL Database. I have build the report on a company server and it seems to work great on PowerBI desktop. I have installed a Data Gateway on the Server which is active and have established the connestions on the PowerBI website. After testing them on Manage Gateways, all data sources of the Gateway are online and good to go. When I go to the report on the website thought it is not working. The visuals are not diplaying and I get an error saying:
"An invalid connection string has at least one of the passed argyments which does not meet the parameter specification. Please check the data source connection string".
The details of the error message are:
Couldn't load the data for this visual
Couldn't retrieve the data for this visual. Please try again later.
Please try again later or contact support. If you contact support, please provide these details.
Activity ID: 687ae9a4-1954-4511-b4c2-0c27e8f3c2de
Request ID: f238ed75-b33d-6eb1-b471-301c18dc237a
Correlation ID: a5027b45-f730-1ec5-3301-34855149a1c4
Time: Tue Jan 07 2020 11:39:53 GMT+0000 (Greenwich Mean Time)
Service version: 13.0.11747.315
Client version: 1912.2.031
Cluster URI: https://wabi-north-europe-redirect.analysis.windows.net/
* Please note that I have exactly the same report on my personal laptop and installed a different gateway there. The report from my personal laptop works fine on the PowerBI website.
Is there an additional step that need to be done when publising from a server?
Anyone with a similar issue or that knows what I should do?
