Kristian
Advocate I
9 years agoStatus:
Completed
OAuth2 authentication method doesn't work with OData for Project Online
Hi I work for different Project Online Customers and create some Power BI reports using OData. For several weeks now the Schedule Refresh isn’t working properly. I tested it for few customers with the standard field ProjectName (/_api/ProjectData/[en-us]/Projects?$select=ProjectName) and always get the same error when I try to update the credentials in Power BI Online “You do not have Persmission to show this site” using oAuth2. Here is a step-by-step guide what I’m doing and at which point I get an error. 1. Open Power BI Desktop, Get Data, choose OData Feed, connect, enter OData URL, hit OK, login in with an Organizational account and Load. 2. Choose ProjectName and show it as a list. Save file (Test.pbix) and publish it to Power BI. 3. Go to www.powerbi.com, log in and select schedule refresh in my new datasets. 4. Now I got following warning: Your data source can’t be refreshed because the credentials are invalid. Please update your credentials and try again. Therefore I go to Edit credentials. Hint: There is no gateway connection and my schedule refresh options are all greyed-out. 5. I choose OAuth2 as Authentication method and try to sign in. Now I got following Error. You do not have permission to show this site ActivityId: 2da8b0d3-1cfb-48b6-9582-b66a903de7fb URL: https://preview.powerbi.com/ErrorPage?code=403&errorType=UnsupportedRedirect If needed I can also send some printscreen or other needed information. I would appreciate any help! Thank you in advance. Kind regards Kristian
3 Comments
- driesvdcNew MemberI have experienced similar authentication issues with PowerBI and Project Online, not sure if it exactly the same: Lately I have been unable to connect the PowerBI Content Paack to "Contoso" demo tenants: I have tried all of the authentication methods available, and none has worked.
- chass
Impactful Individual
Please see the step needed to get Oauth working with Power BI https://community.powerbi.com/t5/Service/OData-or-sharepoint-list-oAuth2-authentication-not-working/td-p/53671/page/2 - fbcideas_migusrNew MemberStatus added:Completed
Recent ideas
Allow Org App Publishing Without Write Permission on Underlying Semantic Models
Allow users to create, curate, and distribute Org Apps without requiring Write permission on the underlying semantic models. Org App distribution should support separation of duties between semantic...KimY1 hour agoFrequent VisitorNew4Views0likes0CommentsExpose Generated SQL/DAX/GQL Queries and Execution Details via Fabric Data Agent MCP
We are integrating Microsoft Fabric Data Agent through MCP into a custom enterprise application and would like to provide users with the same level of transparency that is available when interacting ...Sheetal-Lomate2 hours agoNew MemberNew2Views0likes0CommentsNative Hosting for Lightweight Applications (e.g., Streamlit) Within Microsoft Fabric
Today, when data scientists or analysts want to share interactive prototypes (e.g., Streamlit apps) built from Fabric Lakehouse or Warehouse data, they need to deploy the app externally in Azure serv...deepakpandalai2 hours agoRegular VisitorNew285Views4likes1CommentAllow personal bookmarks to be displayed on the report canvas
Please add a visual or extend the bookmark navigator to display the signed-in user’s personal bookmarks as a clickable list directly on the report canvas. Report viewers should be able to create and...Yacermoussa3 hours agoNew MemberNew4Views0likes0CommentsRequest to Document Flutter Integration for Power BI Embedded Analytics
Hello Power BI Team, I'm a Flutter developer and the creator of flutter_powerbi_embed, a published package for embedding Power BI reports into Flutter applications. I noticed that the official Power ...NehruJr3 hours agoNew MemberNew1View0likes0Comments