Wrong data integrated

[NewTechGirl]

I have a Cloud Provider, Plex Connect, that I am trying to integrate datasets through an ODBC driver to Power BI. I was able to connect but the tables that came through were not our datasets. They looked like sample tables. My ODBC came straight from Plex. What am I missing? 

[darkniqht]

Double-check your ODBC connection settings to ensure you're targeting the correct database and schema, and verify that your user account has the necessary permissions.

If there are multiple databases, make sure you're selecting the right one.

Try refreshing the metadata in Power BI, and if the issue persists, consider reaching out to Plex Connect support for further assistance.

[NewTechGirl]

Thank you Rajendraongole1. I have double-checked my connects and they are accurate. I am waiting to hear back from Plex to see if I was provided with the correct information as I don't know what else it would be. 

[rajendraongole1]

Hi @NewTechGirl -It sounds like you've covered all the major troubleshooting steps, so waiting on Plex support is a good move at this point. If the connection details are correct and the expected tables aren’t coming through.

In the meantime, if you have access to a Plex sandbox or documentation, you might look for options that specify dataset names, schemas, or connection parameters specific to your organization’s environment. Plex support should ideally provide clarity on any access configuration needed for your datasets.

Hope the above suggestion helps

[rajendraongole1]

Hi @NewTechGirl -If Plex Connect has multiple environments (like test, development, and production), make sure you’re connecting to the correct environment. Sometimes ODBC connections default to test environments that contain sample or dummy data.

Review the connection properties in Power BI and in the ODBC Data Source Administrator to confirm they match your actual production database settings.Consult with your Plex Connect admin to ensure your account has access to the correct datasets and that you are connecting to the right environment.

Ref. link FYI

 Analyzing Plex Media Server Data using Power BI – BI Polar (ssbipolar.com)

Ensure that you have the latest ODBC driver from Plex, as older versions may not support all dataset structures or may default to sample datasets.

Hope the above details helps to sort out the issue.