Forum Discussion
How to solve the Power BI Service credential issue
Hi v-luwang-msft and all,
Thank you for all the good suggestions and feedback. Finally, I find the root cause. Issue comes from the excel patch I am using. I was using the excel path generated by share point online sharing, once I update it to the path I copy from the excel info, everything is good now.
Thank you all, always a lot of things to encounter and to learn.
Best,
Na.
Hi bitxln ,
Try another way to get data from sharepoint.(odata)
details refer:
Power BI: Two Way To Get Data From SharePoint List / Library
And a little point :
https://community.powerbi.com/t5/Service/MS-Access-in-Share-Point-issue/m-p/783259
https://community.powerbi.com/t5/Power-Query/Connecting-to-Dynamics-Marketing/m-p/35629
In addition, you said, want the data to keep up to date at any time, you can refer to the next Power BI data refresh of this part of the content, only direct Query connection mode, the data is up to date, because when there is a user click on the report, will send real-time queries to the data, so as to get the latest data, import connection mode of data, pro users up to shcedule refresh 8 times a day, if it is premium space, you can refresh 48 times.
Data refresh in Power BI - Power BI | Microsoft Docs
Did I answer your question? Mark my post as a solution!
Best Regards
Lucien
Hi v-luwang-msft and all,
Thank you for all the good suggestions and feedback. Finally, I find the root cause. Issue comes from the excel patch I am using. I was using the excel path generated by share point online sharing, once I update it to the path I copy from the excel info, everything is good now.
Thank you all, always a lot of things to encounter and to learn.
Best,
Na.
Thanks this worked!
For anyone else with this issue in Excel in the start screen Go Home -> Recent Files -> find the file and click the 3 dots then select "Copy path".
This gave me a path like:
https://<company>.sharepoint.com/sites/<site>/<folder>/file.xlsx
whereas befor i had a path like:
https://<company>.sharepoint.com/:x/r/sites/<site>/<folder>/file.xlsx
With the extra "/:x/r" that worked in PBI desktop but online gave the OAuth not supported error.Thank you very much I solve my problem. ⭐⭐⭐⭐⭐
What is your solution to solve the issue. Which excel path should be used? I would appreciate your cooperation and responsens. Thank you!
