Forum Discussion

DebbieE's avatar
DebbieE
Community Champion
6 years ago

Creating a flow, getting constant errors

As a test Im moving my Adventure Works transformation from power BI into a Data flow. they are all fairly simple. Create a column, split column etc et but every step of the way im getting nothing but...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

HI DebbieE ,

Can you please share more detailed information to help us clarify your scenario? It is hard to troubleshooting from the session id. (e.g. datasoruce type, connection mode, datasource credentials, gateway config...)

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng

  • DebbieE's avatar
    DebbieE
    Community Champion
    6 years ago

    I have the Adventureworks Data Wareshouse Data Set up on an Azure Data base so i dont need a gateway connection

     

    Authentication method (Basic) with a Username and password

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      HI DebbieE ,

      >>I have the Adventureworks Data Wareshouse Data Set up on an Azure Data base so i dont need a gateway connection

      Do you mean Azure SQL data warehouse? Can you confirm your credentials has enough permission to access the remote server?

      In addition, did these notices appear when you connect to datasource or appear when you edit on a connected query table? If you mean edit operations, I'd like to suggest you take a look at computed entities(premium license only) which allow doing some in-query transform operations:

      Using computed entities on Power BI Premium 

      Regards,

      Xiaoxin Sheng

      • DebbieE's avatar
        DebbieE
        Community Champion
        6 years ago

        I have ower permissions and Im using an Azure SQL Data base.

         

        I dont have Premium. Im on Pro. are dataflows worth doing if your not in Premium?