Pipeline & data refresh issues

[lhuynh]

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 Power Bi.

We are looking to create and share sales/perfomance reports to 3 different departments. Sales, Property Management & Leasing. Within Sales we would also like to restrict view to results that is just relevant to each of the 3 sales agents.

Source of data will be a combination of the following;

SQL database & excel spreadsheets

As an example;

We have created a simple report in power bi desktop pulling data from the sql database and an excel spreadsheet. The spreadsheet and report is saved in a folder in Microsoft Teams.

I have published the report to development pipeline and then immediately deployed to test.

I note the following;

Data refresh at development appears to refresh without errors

Data refresh at test both failed and data source creditentials in settings both have crosses next to them.

Any advice on what I am doing wrong or how to configure properly?

[v-yueyunzh-msft]

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]

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?

[v-yueyunzh-msft]

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 |...

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]

Hi Aniya,

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

[v-yueyunzh-msft]

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

[lhuynh]

Hi Aniya,

Sorry could you clarify, the OAuth authentication works at development but when deployed to test it doesnt work. Is this a system bug that needs to be fixed?

[v-yueyunzh-msft]

Hi , @lhuynh 
Yes, this is strange,it works in your development and not work in test. But according to your error message, there is indeed a corresponding BUG, for your problem, I recommend that you open a support ticket for in-depth troubleshooting.

If you are above a Power BI Pro licensee, you can create a support ticket for free and a dedicated Microsoft engineer will come to solve the problem for you.

It would be great if you continue to share in this issue to help others with similar problems after you know the root cause or solution.

The link of Power BI Support: https://powerbi.microsoft.com/en-us/support/

For how to create a support ticket, please refer to https://community.powerbi.com/t5/Community-Blog/How-to-create-a-support-ticket-in-Power-BI/ba-p/6830...

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]

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

[Anonymous]

@lhuynh 

Please follow the below video to set it up-

Tutorial: Deployment Pipelines in Power BI - YouTube