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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
sedkimic
Frequent Visitor

Missing credentials after deploying datamart from development to test

I have a datamart as part of deployment pipeline.  After deploying the datamart from development to test, the refresh fails and I receive a "there was a problem refreshing your datamart" message.  When I open the query editor for the datamart in the test environment, all the querys connecting to external data sources, i.e. on-prem databases, are returning "we could not evaluate this query due to missing or invalid credentials."  When I select the "configure connection" dialog I see that the gateway connection is properly referenced.

 

The datamart refreshed (and continues) to refresh properly in the development environment.  How do I get it to refresh properly in the test environment?

1 ACCEPTED SOLUTION
sedkimic
Frequent Visitor

Nevermind - figured it out.  I had multiple data sources that were being consumed in the datamart.  I had to update the connection for each one (although the UI suggests that they are already configured correctly) before any of the queries would work.

View solution in original post

2 REPLIES 2
sedkimic
Frequent Visitor

Nevermind - figured it out.  I had multiple data sources that were being consumed in the datamart.  I had to update the connection for each one (although the UI suggests that they are already configured correctly) before any of the queries would work.

Can you please elaborate more on what you exactly did..Because I have deployed my datamart, sematic and report from development to test environment in Power BI Service. The refresh for the datamart in the test environment fails, also the semantic model refresh fails and the report does not have any data. The datamart, semnatic and report in the development works fine..What is wrong with the datamart in test? 

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

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