The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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?
Solved! Go to Solution.
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.
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?
User | Count |
---|---|
39 | |
13 | |
12 | |
12 | |
11 |
User | Count |
---|---|
51 | |
35 | |
27 | |
21 | |
18 |