Forum Discussion
Error: Value should be defined
Hi friends! I was trying to create a dataflow using an SQL Server Database. I am currently facing this issue below. Could you guys help me find the solution and explain why this is happening? I...
I have had the same error message while creating a new dataflow from MariaDB. I was not able to esablish the connection with MariaDB nor MySQL datasources. Therefore, I have create a ODBC source.
I was able to solve this issue with following steps:
- Make sure that on the machine where your Power BI-Gateway is installed you have the respective database driver.
- Create a ODBC source locally and in your workspace setting of your workspace
- Create localy (on the Power BI-Gateway machine) a pbix file with connection to the ODBC source and test your query.
- Create a new dataflow in the workspace using the empty query template.
- Paste the localy created M query into the extended editor of the new dataflow.
- Try to load data. You will get an error. Set the remote ODBC source of your workspace and try again.
Anonymous Can you explain further on your last step? What do you mean by set the remote ODBC source of your workspace and try again