Forum Discussion
Dataflow will only refresh in edit mode
Hi Anonymous ,
Based on the information you have provided, the data stream appears to be able to successfully fetch data from the REST POST API while in edit mode, but encounters an error when attempting to refresh after saving and closing. There are several steps you can take to troubleshoot and possibly resolve this issue:
- Ensure that the Simplesat token used for authentication is still valid outside of edit mode. If the token has expired, authentication may fail.
- When using Web.Contents, it is recommended to separate the base URL from the relative path, especially when using dynamic data sources.
- Make sure that the data source settings in Power BI are set to use anonymous authentication since the authentication token is passed in the header.
If you are still experiencing problems after trying these steps, please provide more detailed information about the following:
- Whether the authentication token has specific expiration or usage constraints that may affect its validity outside of edit mode.
- Any changes made to data source settings or M-code after the problem was discovered.
Best Regards,
Ada Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
Based on the information you have provided, the data stream appears to be able to successfully fetch data from the REST POST API while in edit mode, but encounters an error when attempting to refresh after saving and closing. There are several steps you can take to troubleshoot and possibly resolve this issue:
- Ensure that the Simplesat token used for authentication is still valid outside of edit mode. If the token has expired, authentication may fail.
- When using Web.Contents, it is recommended to separate the base URL from the relative path, especially when using dynamic data sources.
- Make sure that the data source settings in Power BI are set to use anonymous authentication since the authentication token is passed in the header.
If you are still experiencing problems after trying these steps, please provide more detailed information about the following:
- Whether the authentication token has specific expiration or usage constraints that may affect its validity outside of edit mode.
- Any changes made to data source settings or M-code after the problem was discovered.
Best Regards,
Ada Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I tested creating a report with the same query, published it to a workspace and updated the dataset. That worked fine.
The datasets have the parameter option in the settings, which isn't an available setting in a dataflow. I guess that's where the issue lies.. Any workaround?