Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
From several days I am facing a bad behaviour of OData connection in a dozens of PBI report that works correctly for a couple of years.
I exclude any network connection issue. In fact on the same report I have a connection to Azure istance that works properly if I try to refresh only that file
tcp:MyServer.database.windows.net,1433
Moreover, reading some article on the Web, I did the test below and once again it works
let Source = OData.Feed("http://services.odata.org/northwind/northwind.svc/", null, [Implementation="2.0"]), Alphabetical_list_of_products_table = Source{[Name="Alphabetical_list_of_products",Signature="table"]}[Data] in Alphabetical_list_of_products_table
Then it seems the issue arise while PBI try to establish the OData connection to SPO lists
Any ideas/suggestion will be appreciated. It would be great I could solve the issue before Jan 7.
Just to start better
Thanks
Solved! Go to Solution.
Does this issue happens both in power bi desktop or power bi service? If the issue occurs both on desktop and service, please check if the access token of the rest api you use is expired. In addtion, if the issue only happens on power bi service, please check if you have configured the credentials properly via dataset -> data source credential.
Regards,
Jimmy Tao
Does this issue happens both in power bi desktop or power bi service? If the issue occurs both on desktop and service, please check if the access token of the rest api you use is expired. In addtion, if the issue only happens on power bi service, please check if you have configured the credentials properly via dataset -> data source credential.
Regards,
Jimmy Tao
many thanks for your kind reply. The issue is related only to desktop version.
As you suggested, I checked again data source credential. I do not know why but one of the data source wa not properly set.
It was ok till last Dec 21. In fact all the reports were updated: last refresh Dec 21.
Thanks again
User | Count |
---|---|
111 | |
105 | |
100 | |
77 | |
44 |
User | Count |
---|---|
143 | |
142 | |
122 | |
100 | |
57 |