Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
hello i keep getting this error when i try to add an excel file i have in my reports to an enterprise gateway. the SQL source connects no problem.
it keeps saying invalid credentials.
looking for help on this please?
thanks
Amrita
Solved! Go to Solution.
Hi. I'm not sure why you have that error but there is an easier way to configure this. You can turn on an option in the "Gateway Settings" menú to turn on hybrid refrehes (using gateway and cloud directly connected). You can read more about it in this post showing the number 1 as the option I'm talking about
https://blog.ladataweb.com.ar/post/647097339965734912/powerbigateway-opciones-de-interés-en-puerta-d...
After you turn that one you can just "Edit Credentials" in the dataset settings two lines above the schedule refresh to update that data (onedrive) without gateway.
I hope that make sense
Happy to help!
Hi. I'm not sure why you have that error but there is an easier way to configure this. You can turn on an option in the "Gateway Settings" menú to turn on hybrid refrehes (using gateway and cloud directly connected). You can read more about it in this post showing the number 1 as the option I'm talking about
https://blog.ladataweb.com.ar/post/647097339965734912/powerbigateway-opciones-de-interés-en-puerta-d...
After you turn that one you can just "Edit Credentials" in the dataset settings two lines above the schedule refresh to update that data (onedrive) without gateway.
I hope that make sense
Happy to help!
thanks very much!! this is perfect.