Forum Discussion

lhuynh's avatar
lhuynh
Regular Visitor
3 years ago

Pipeline & data refresh issues

Hi All,   I am very new to Power Bi. Not familiar with how to troubleshoot some initial problems I am having at various stages of deployment from Dev to Test workspaces.   Backgound on our use of...
Need Help
v-yueyunzh-msft's avatar
v-yueyunzh-msft
Community Support
3 years ago

Hi , lhuynh 

Based on your problem description, I noticed this detail "Data refresh at test both failed and data source creditentials in settings both have crosses next to them", so I think that the dataset in your test phase workspace is not properly configured with credentials in the data source definition after being deployed. Because they show a cross next to it means that the credentials are incorrect, I recommend that you try to configure correctly in the data source definition and gateway for these datasets that report errors to ensure that no crosses exist, and then try data refresh:

Configure scheduled refresh - Power BI | Microsoft Learn

 

 

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

 

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

lhuynh's avatar
lhuynh
Regular Visitor
3 years ago

Hi Aniya,

 

If the credentials in Development works and we immediately deploy to test, do you know why the credentials would fail at test? or why we are required to re-enter them at test?

  • lhuynh's avatar
    lhuynh
    Regular Visitor
    3 years ago

    Also, what would be the authentication method for a spreadsheet saved in a Teams directory?

  • v-yueyunzh-msft's avatar
    v-yueyunzh-msft
    Community Support
    3 years ago

    Hi , lhuynh 

    In the target stage, item properties that are not copied, remain as they were before deployment. New content and new items are copied from the current stage to the target stage.

    The following dataset properties are also not copied during deployment:

    • Role assignment

    • Refresh schedule

    • Data source credentials

    • Query caching settings (can be inherited from the capacity)

    • Endorsement settings

    For more information, you can refer to :
    Deployment pipelines, the Power BI Application lifecycle management (ALM) tool, process - Power BI | Microsoft Learn

     

    Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

     

    Best Regards,

    Aniya Zhang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

     

     

    • lhuynh's avatar
      lhuynh
      Regular Visitor
      3 years ago

      Hi Aniya,

       

      I have entered the exact credentials that worked at development into test and it doesnt not accept them.

       

       

      • v-yueyunzh-msft's avatar
        v-yueyunzh-msft
        Community Support
        3 years ago

        Hi, lhuynh 

        According to the screenshot you provided, I found the corresponding error message "The OAuth authentication method isn't supported for this data source" on the internal problem website and has been submitted to the product team. ICM number: 349438899.

        Research on this issue is still ongoing in collaboration between product groups and technical engineers, so I'll keep you informed if there are any updates.

         

        Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

         

        Best Regards,

        Aniya Zhang

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly