Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
3 years ago

Power BI dataset data source with another source in Service

I have published a dashboard to the power bi service whose data sources are: (1) a dataset of a power bi project and (2) a csv file. In local I read the data well but when I upload it I see the following message "there is no gateway to access the data source". If I upload the power bi without the second data source (2) it works correctly.

I have tried to change the csv data source for a Mysql query but the same thing keeps happening to me.

Do you know why it can be?

Thanks in advance!

3 Replies

  • MAwwad's avatar
    MAwwad
    Icon for Solution Sage rankSolution Sage
    3 years ago

    Hello,

     

    Try to have each data source as a dataflow and then use the 2 different dataflows to create the report.

    • Syndicate_Admin's avatar
      Syndicate_Admin
      Icon for Administrator rankAdministrator
      3 years ago

      Hello @Syndicate_Admin , thanks for your comment.

      I tried uploading the second data source (csv) as a Power Bi dataset and so if I successfully take the two data sources in Power Bi Service

  • Syndicate_Admin's avatar
    Syndicate_Admin
    Icon for Administrator rankAdministrator
    3 years ago

    Hello @Syndicate_Admin, thanks for your comment.

    I tried uploading the second data source (csv) as a Power Bi dataset and so if I successfully take the two data sources in Power Bi Service