Forum Discussion
Error when trying to create a dataflow gen 2.
YairCzitrom , let's debug this - can you share the session ID where you are running into this issue.
1. In your dataflow editor, click Options -> diagnositics -> copy the session ID
2. If possible, run a HTTP capture via fiddler or browser dev tools
3. Repro the issue where in the output destination selector, it produces "Something went wrong"
4. If you are running the network capture, save it locally
(Export HAR...)
Keep the file for future references and post the session ID here.
Also, since this is routing to a gateway, make sure you turn on gateway logging (additional logging, see: https://learn.microsoft.com/en-us/data-integration/gateway/service-gateway-performance#slow-performing-queries) before the repro.
Once you reproduced the error, flush the logs and zip them up for future reference
Guys.... it is fixed
My bad... after all.
It IS all about the fire wall.
We open it on the on-prem server BUT it is not enough!
AS we are hosting it on some data center, THEY have to open the firewall and it will work.
The biggest problem now is that they are not happy about it as we open another port in thier firewall, and they cannot do the *.domainname roles apperently so they open for all!!!
Microsoft support - is there any way to give them a specific address/s to open?
Glad to hear that it's firewall after all. For specific IP addresses, you can check the PowerBI service tag - Power BI\Fabric uses specific preallocated IP addresses for inbound and outbound connectivity, the entire range is listed here:
Download Azure IP Ranges and Service Tags – Public Cloud from Official Microsoft Download Center
You can probably narrow it down to your specific cluster region instead of the entire range. Find out which FQDN you had to allowlist for this to work, and then nslookup on it. Then you can find the PowerBI's IP addresses in that region in the document above.
What is i put in the firewall role the urls of the end point of the lakehouse, warehouse and the staging DB's?
Will that be enough?
