Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Long story short:
A third party just did a massive code change for the front end as it is a developing platfrom and they decided to change the name of the server and the db.
So i simply went through all the relivant PBIXs and changed the server from the server name to the IP and also changed the DB from NM3-Live > NM-Production. It has worked for 99% of our models. However for one of them it worked in the desktop and it refreshes a treat, however on publishing it to the services, the old connection to NM3-Live is still there and so is the new NM-Production.
This model is actually a child for a mini-project for sales and the mother model has worked fine. I have triple checked the connections in the desktop, there is nothing mentioning the NM3. Is there a way to find it using DAX Studio? Or has this PBIX corrupted some how? Any ideas?
I have tried:
- Using an old copy of the report also.
- I have deleted it from the workspace and app and tried republishing
- I have tried publishing it to a workspace which has never had this PBIX.
I cannot reproduce the issue. You may try to Delete a dataset.
The examples of what i am seeing on the desktop and in the workspace
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |