Forum Discussion

rileywells's avatar
rileywells
Frequent Visitor
10 months ago
Solved

Cannot create visualisations/report after importing data from a Fabric SQL database

I have been following the Microsoft tutorial for creating a translytical data flow: https://learn.microsoft.com/en-us/power-bi/create-reports/translytical-task-flow-tutorial   I am up to the stage ...
Need Help
  • rileywells's avatar
    rileywells
    10 months ago

    Thanks, this worked.

     

    Just for anybody else who has this issue, when you connect to your SQL database, you need to hit the arrow next to the "Connect" button, and select "Connect to SQL endpoint" instead of "Connect to OneLake".

     

     

lbendlin's avatar
lbendlin
Super User
10 months ago

You need to connect to your Fabric data source in Direct Query mode.  Otherwise your data write-back will not reflect back into the UI.

  • rileywells's avatar
    rileywells
    Frequent Visitor
    10 months ago

    Thanks, this worked.

     

    Just for anybody else who has this issue, when you connect to your SQL database, you need to hit the arrow next to the "Connect" button, and select "Connect to SQL endpoint" instead of "Connect to OneLake".