Forum Discussion

abhijeetdt123's avatar
abhijeetdt123
Regular Visitor
6 months ago
Solved

Visuals Disappear After Publishing – Issue Only with Merged Query (Shared Folder + BW4)

Hi all, I have a Power BI report that uses two data sources: 1. SAP BW/4HANA 2. Excel files stored on an internal shared folder Everything works perfectly in Power BI Desktop, but after publi...
Need Help
  • Anonymous's avatar
    Anonymous
    6 months ago

    Hi abhijeetdt123,

     

    Thank you for reaching out to the Microsoft Fabric Forum Community, and special thanks to tayloramy  for prompt and helpful responses.

     

    This happens because Power BI Service is more strict than Power BI Desktop when you combine data from different sources. Even though the report works on your machine, the visual disappears in the Service because the merged query  fails while running there. This is usually due to gateway setup, privacy level differences, or missing access to the shared folder.

    Make sure both data sources are connected through the same gateway, have the same privacy level, and that the gateway account can access the shared folder. For a more reliable solution, load BW data and shared folder data separately and then merge them after they are loaded, instead of merging the raw sources directly.

     

    Thanks & Regards,

    Prasanna Kumar

Anonymous's avatar
Anonymous
Not applicable
6 months ago

Hi abhijeetdt123,

 

Just following up to see if the Response provided by community members were helpful in addressing the issue. if the issue still persists Feel free to reach out if you need any further clarification or assistance.

 

Best regards,
Prasanna Kumar