Forum Discussion

PBIDEV_10's avatar
PBIDEV_10
Helper II
2 years ago
Solved

Composite model publishing issue

Hello Gurus I have a published power BI dataset in a workspace which I am using as a source in one report which is in another workspace. Then I got one requirement to include an excel sheet in the s...
Need Help
Show and Tell
  • edhans's avatar
    edhans
    2 years ago

    The data source has to be the same. So likely instead of using O:\ in Power Query, you need to use the UNC name of the network path that the gateway is using. You may need to contact your IT department or whomever set up the gateway datasource to ensure they are the same.

edhans's avatar
edhans
Community Champion
2 years ago

The data source has to be the same. So likely instead of using O:\ in Power Query, you need to use the UNC name of the network path that the gateway is using. You may need to contact your IT department or whomever set up the gateway datasource to ensure they are the same.

  • edhans's avatar
    edhans
    Community Champion
    2 years ago

    And FWIW, if you can, just put that Excel file in a Teams or SharePoint folder, then use the SharePoint connector to get to it. Bypasses all of the gateway hassle as SharePoint is a cloud resource.

    • PBIDEV_10's avatar
      PBIDEV_10
      Helper II
      2 years ago

      Thank you so much for your reply. Yes we are now thinking to move excel sources to sharepoint so that we dont get issues like this. But for now the issue is solved with the correct network path.