Forum Discussion

learner03's avatar
learner03
Post Partisan
11 months ago
Solved

Can't Save Dataflow

we use the query the table, it retrieves the data and when we save the table in the dataflow it throws this error message   Odbc.Query("dsn=GLOBALERP", "     SELECT      ID Job_Status_ID,     na...
Need Help
  • Anonymous's avatar
    Anonymous
    11 months ago

    Hi learner03,

    Thank you for reaching out to the Microsoft fabric community forum. 

     

    The error message you’re seeing (“Can’t save dataflow – Unknown error”) usually appears when the ODBC connector isn’t fully set up in the Power BI Service.

    While the ODBC connector is supported for Dataflows (see Microsoft documentation: ODBC connector), it must be configured through the On-premises Data Gateway. Make sure the DSN (GLOBALERP) is set up correctly on the gateway machine, mapped in the Service under Manage Gateways, and that the gateway is online.

    Try running a simple query like SELECT TOP 1 * FROM JobStatus to check if the connector is working, and confirm that your query’s column names are unique and not reserved words, as duplicates can prevent the dataflow from saving.

    If the issue persists, enable diagnostics in the Service and share your gateway configuration details for further investigation.

    Hope this helps, feel free to reachout for any further questions.

     

    Thank you.

Anonymous's avatar
Anonymous
Not applicable
11 months ago

Hi learner03 ,

 

We haven’t received an update from you in some time. Could you please let us know if the issue has been resolved?
If you still require support, please let us know, we are happy to assist you.

 

Thank you.