Not sure if I should post this here or in the desktop forum, let me know if that is a better place.
My Issue:
So i have currently been using a ODBC driver (called CData) to pull data from our ERP systems. This has been working fairly well except now i need to view a custom field that the driver doesnt provide automatically. They gave me a round about way to get that field but i am kinda lost on where to proceed. I am no developer and this part of Power BI and SQL is new to me.
Their response:
First you will need to set a value for the Location in your ODBC connection settings. This will tell the driver where to store and look for additional schemas. Then you will need to execute the stored procedure by running something like the following:
EXEC CreateSchema @Tablename=’<your table>’
This will create a schema file in the Location that you have specified. You should then be able to add a new field to this file, following the examples in the file which already exist. The next time you use the ODBC driver after restarting PowerBI, you should see the updated schema in your Table/View listing.
My question:
Has anyone had any experience with this sort of thing when it comes to Power BI. Ive reached out to the company but they are already gone for the day, so i figured id try to see if i could do it on my own.
Thanks!
