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 have a generic username and password that has access in the database. In PBI Desktop, I was able to connect this exact same datasource with no error.
Thank you in advance!
6 Replies
Hi JofrainVisda ,
You can reference the following document which is about using dataflow connector.
Power Query Dataflow connector - Power Query | Microsoft Learn
Best Regards,
Community Support Team _ xiaosunIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
Thank you for the time. But what I was trying to do is to create a dataflow inside a workspace and the data will be coming from SQL server.
Same problem
I didn't find a solutionI 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.
I have exactly the same problem...
