Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
lhuynh
Regular Visitor

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

9 REPLIES 9
v-yueyunzh-msft
Community Support
Community Support

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

 

vyueyunzhmsft_0-1670292929505.png

 

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

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?

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

 

 

Hi Aniya,

 

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

 

lhuynh_0-1670988631203.png

 

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

 

 

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?

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

 

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

Anonymous
Not applicable

@lhuynh 

Please follow the below video to set it up-

Tutorial: Deployment Pipelines in Power BI - YouTube

 

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.