Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi everyone,
I’m really hoping someone can point me in the right direction here. Connection is via dataflow from Dynamics 365 but I’m having a credentials issue that I can’t seem to resolve. Hoping I’m missing something obvious.
At first credentials are greyed out until I open desktop, then it becomes visible and I can see the second screenshot:
At first credentials are greyed out until I open desktop, then it becomes visible and I see this:
The first set of credentials are fine and connected in the same way via the same URL. Desktop and system refreshes are successful. I’ve cleared the cache in desktop via options and signed in again via service.
Hoping someone help with the confusion please? Really appreciate any help. Thanks
The 2 things I try for this would be:
1) Delete this completely from service and republish this again and see if this works.
2) The SQL error generally points that the SQL server does not allow outbound connections (whitelisting the service IPs might be needed).
Thanks for your response, the credentials are for my raw data connection to Dynamics 365, not for a report, would 1. work?
For 2, the odd thing is it's using this connection for the Dataflow.
For the first screenshot, it's asking me to remove the https:// but I can't seem to see where I can edit this as all sources for data in direct query point to the dataflow.
You might have to explain what exactly you are trying to do. I am confused now and don't know what you are trying to achieve here.
Morning, everything is refreshing as normal anyway, I can't identify what the two credential issues are referring to.
Hi @Sannat
What happens if you had to connect to the data directly in Power BI desktop instead of the dataflow does that refresh successfully?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
56 | |
19 | |
18 | |
18 | |
9 |