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.
Hi all,
I have create 2 same report using different datasource instance .I have used Postgresql Unicode ODBC driver classes for both report.I added both datasource in Instances in Same Driver classes with different DSN .Connection everything ok..And i can fetch data on both report using same driver with two datasource instances.But i faced some issue after publishing 2 reports to same service accounts under same gateway..I added one of the datasource under gateway sucessfully .But when i try to added another report datasource under the same gateway, error occured.
But i have no issue while try to fetch data from same database in power bi desktop.If i changed driver class i will get db connection correctly.Why we can't connect multiple datasource instance to same odbc driver classes using enterprise gateway?Plse help?
Solved! Go to Solution.
Think of the gateway as a PC running without adult supervision. You need to exactly replicate the ODBC setup in your PC, including installing the driver and creating (and testing!) the different connections.
Have you confirmed on all gateway cluster members that your ODBC drivers are installed and the connections are set up and working?
Think of the gateway as a PC running without adult supervision. You need to exactly replicate the ODBC setup in your PC, including installing the driver and creating (and testing!) the different connections.
that's all i did and am getting connections correctly in power bi desktop.Issue found after publishing these report to power bi service and try to add these datasource to gateway...at that time am getting error
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
129 | |
106 | |
106 | |
86 | |
72 |