Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hello everyone,
I have a premium account. I created a dataflow connected to a sharepoint.
I made the report on Power BI desktop and I'm connected to the dataflow. I set an automatic update for the data flow (on the online workspace). When I refersh the data in power query , everything is ok.
Then a publish the report on the workspace and create an app. When I open the the report or the app via my online workspace, the datas are not actualised, even if I press the "refresh/actualise" button in the app. I don't understand why because the last update on the dataflow is more recent than the display in the report.. How can I update the online app or the online report ?
Thank you in advance for your help !
Solved! Go to Solution.
Can you open and show me these 2 please?
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
Hi @rbech
Scheduled refresh must be configured by the owner of the semantic model.
Your ability to make changes to the semantic model is dependent on ownership of the semantic model. If you're not the owner, a warning is displayed stating that you're viewing the section of the semantic model information in read-only mode because you're not the semantic model owner. To make changes, you must either contact the semantic model owner to make changes, or take over ownership of the semantic model.
Link of how to take over the semantic model:
Take Control of a Semantic Model (businesscentralinsights.com
Link of Scheduled refresh:
Configure scheduled refresh - Power BI | Microsoft Learn
Best Regards,
Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @v-zhengdxu-msft ,
Thanks for your reply.
The semantic model is configured under my account and the "Data source credential" section is inaccessible (grayed out).
Hi @rbech
You can't build a report on top of a Dataflow. Certainly the report is built on top of a sematic model that is connected to the Dataflow. Therefore right after the refresh of the dataflow has finished the semantic model attached to the dataflow needs to be refreshed in its turn. This way data in the report will be updated.
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
Hi @aj1973 ,
Thank you for your reply !
I tried to create an automatic refresh of the semantic model but in the parameter I don't see how to do that (Gateway connection options are grayed out).
Actually the dataflow is connected to a sharepoint of an other organisation with a dedicated MS login and password. I don't see any option to log in in the semantic model ... ?
You need to Take over the ownership of the semantic model
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
Hello @aj1973 ,
I don't see this button but I think it's already the case as I see
This is the error message :
Erreur de source de données: | L'actualisation planifiée est désactivée car au moins une source de données n'a pas d'informations d'identification. Pour redémarrer l'actualisation, accédez à la page des paramètres de ce jeu de données et entrez les informations d'identification pour toutes les sources de données. Ensuite, réactivez l'actualisation planifiée. |
Maybe it has something to do with the fact that the connection id to the remote sharepoint is another MS account? But as I said, the actualisation works for the dataflow.
Thank you again for helping me.
Ok I see,
The button is not there because you are the owner.
Now it's a bit confusing here, Your Semantic Model is connected to the Dataflow only or to Both : Dataflow and external Sharepoint?
Can I see the lineage please?
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
Hi @aj1973 ,
Here is. "Table de correspondance" & "coefficient" are 2 "static" excels sheet (on my onedrive) . Sharepoint (dataflow) is connected to the external sharepoint (where datas needs to be frequently refreshed). Would the problem come from these two excel files stored on my own drive?
Can you open and show me these 2 please?
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
Ok the authentication issue you have is coming from these 2 sources
I see you have a Gateway in place. is it a personal Gateway or Standard? Do you have the permission to use it?
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
52 | |
38 | |
31 | |
29 | |
21 |