Actualization of powerBI online dashboards fails

BaudouinNP · 2 November 2022 14:23

Hi everybody,

In my exploration of Specke and PowerBI, I have another feedback to give you

After the publication of a Power BI Desktop Dashboard online to Power BI (Web), it is theoretically of course possible to update your online dashboard with the changes you have been doing on the Desktop App.
In our case, we face an error because of the data source → Speckle

Did you meet this problem before ?

Here are some forum contents that might be helpful:

teocomi · 3 November 2022 19:08

Hey @BaudouinNP ,

@AlanRynne might correct me, but I think that’s because our Speckle connector has not been published yet to the Microsoft Store and so it won’t work in PoerBI online.

We definitely have this on our roadmap and will keep you up to date!

AlanRynne · 4 November 2022 09:57

This is a “limitation” in PowerBI’s side. As far as I’m aware, the only way to refresh a custom connector online is by setting up your own on-premises data gateway.

BaudouinNP · 4 November 2022 14:55

Would it be possible for you to explain a little what is this on-premises data getaway ?

AlanRynne · 7 November 2022 11:52

Sadly, I know as much as it says in the docs linked above. I have no experience with on-premises data gateways but as I understand it it’s just a computer, somewhere on the internet, that will do the refreshing for you.

Since you have control over that machine, it will allow you to run any custom connector in it.

JhnA_C · 16 December 2023 18:59

Hola, para hacerlo, solo se puede en “Gateway Personal Mode”
Pasos:

Descarga e instala “Gateway Personal Mode” Power BI Gateway | Microsoft Power BI
en el Menú del Gateway ->Conectores, verifica que el “Custom Connector Speckle” sea reconocido, para aquello talvez tendrás que guardar el conector en la carpeta que aparece por defecto en mi caso, tuve que crear y guardar el conector en la carpeta que detecta automáticamente el Gateway, me refieroa: C:\Users\xx\Documents\Power BI Desktop\Custom Connectors
Al realizar estos cambios ya debería aparecer en power bi online en el modelo de dato → Semantic model >Gateway and cloud connections y >Data source credentials
en la sección de Data source credentials, deberás actualizar las credenciales, en mi caso fue por token (Key), ya que no funcionó de otra manera. También fíjate si tienes otra fuente de datos que se combine con speckle, tienen que tener ambos el mismo nivel de seguridad, cuando actualices las credenciales, es decir, ambos “Organizativo” o “Público”

Saludos

gokermu · 18 December 2023 07:03

Thanks for sharing your findings @JhnA_C !

jonathon · 19 December 2023 17:11

For the reference of the original topic (all credits and critics to google translate):

JhnA_C:

Hello, to do this, you can only do it in “Gateway Personal Mode”.
Steps:

Download and install “Gateway Personal Mode” Power BI Gateway | Microsoft Power BI

In the Gateway Menu → Connectors, verify that the “Custom Connector Speckle” is recognized, for that you may have to save the connector in the folder that appears by default in my case, I had to create and save the connector in the folder that automatically detects the Gateway, I mean: C:\Users\xx\Documents\Power BI Desktop\Custom Connectors

When you make these changes, it should already appear in PowerBI online in the data model → Semantic model >Gateway and cloud connections and >Data source credentials
In the Data source credentials section, you will have to update the credentials, in my case it was by token (Key), since it did not work otherwise. Also check if you have another data source that is combined with speckle, they both have to have the same security level, when you update the credentials, that is, both “Organizational” or “Public”