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
Add a Native Option to Distinguish "No Selection" from "Select All" in Slicers
Summary Today, Power BI slicers treat “Select All” and “No Selection” as equivalent filtering states. While this behavior is technically efficient, it is often unintuitive for report consumers. M...ealco-mc2 hours agoNew MemberNew3Views0likes0CommentsHybrid appearance: Dark mode UI with light/white Data (Table) view grid
Summary Power BI Desktop Dark mode applies to the entire application, including Table/Data view. Report themes can style visuals on the report canvas, but they do not change the Data view grid. Ther...Aryadne_Rocha6 hours agoNew MemberNew5Views0likes0CommentsRoll back a report through the deployment pipeline without effecting any artifacts in both stages.
Let's consider environment of three stages: DEV → UAT → PROD A report was accidentally published directly to PROD, bypassing the deployment pipeline. The report has already been distributed to s...v-viputta16 hours agoMicrosoft EmployeeNew27Views9likes0CommentsSubscribe hidden page / subscribe to a bookmark
today you can not send email remainders (subscribe) pages that are hidden. sometimes you hide pages so you can access them through bookmark but you don't want them to show in the general view. but ...eitanl6 hours agoNew MemberNeeds Votes1.1KViews96likes11CommentsFeature Request: Search functionality in Power Query Queries pane
Power Query becomes increasingly difficult to navigate as the number of queries grows. In real-world Power BI projects, it is common to have 50, 100, or even 200+ queries across multiple folders or g...AbhishekDA16 hours agoNew MemberNew12Views1like0Comments