Forum Discussion

Charley194's avatar
Charley194
Frequent Visitor
2 years ago
Solved

Error when selecting data destination in Dataflow Gen2

I have built a very simple query in Dataflow Gen2, select * from dbo.table, which returns a small amount of data.  There are no steps after this.  I am attempting to push this data into an Asure SQL ...
data engineering
Data Integration
Fundamentals
  • Charley194's avatar
    Charley194
    2 years ago

    I dont know, is this something to consider?

    Though I have solved the issue now.  Update the Power BI gateway and that problem was solved.



AndyDDC's avatar
AndyDDC
Most Valuable Professional
2 years ago

Hi Charley194 is this an Azure SQL Database (not MI).  If so, what service tier is the Azure SQL DB set to?

  • Charley194's avatar
    Charley194
    Frequent Visitor
    2 years ago

    I dont know, is this something to consider?

    Though I have solved the issue now.  Update the Power BI gateway and that problem was solved.



    • AndyDDC's avatar
      AndyDDC
      Most Valuable Professional
      2 years ago

      It's certainly something to confirm, I never know whether certain features work with certain editions/tiers of SQL Databases.  Glad you found the solution though, great news.

    • v-cboorla-msft's avatar
      v-cboorla-msft
      Microsoft Employee
      2 years ago

      Hi Charley194 

       

      Glad that your query got resolved.
      Please continue using Fabric Community for any help regarding your queries.