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
extend storage capacity of varchar(8000) to varchar(max) for warehouse
The maximum string length of 8000 is often considered too short to store longer descriptive data or embed a JSON value within a text field in a database. Dividing the data into smaller chunks and st...c_mettler6 hours agoNew MemberCompleted3.3KViews61likes13CommentsAdjust column width in SQL Analytics Endpoint user interface
I can't see the column names and cell values in some of the columns in my tables in SQL Analytics Endpoint because the column width is too narrow. Also, the tooltip also doesn't show the entire...frithjof_v6 hours agoCommunity ChampionCompleted4.2KViews75likes8CommentsIn TableEX visual when using Custom tooltip, it shows below it the automatic "-> Drillthrough >"
Using in the Power Bi's Service Cloud. In TableEX visual when using Custom tooltip, it shows below it the automatic "-> Drillthrough >" and selects & clicks the drillthrough page. In TableEX vis...LR38 hours agoRegular VisitorNew4Views0likes0CommentsAllow Power BI subscription sender identity to be configured
The new Power BI subscription delivery platform changed existing subscriptions so that notification emails now show the subscription owner as the sender instead of mailto:[email protected]...bbussey10 hours agoRegular VisitorNew20Views4likes2CommentsSupport Workspaces folder pairing across Fabric Deployment Pipeline stages
Fabric Deployment Pipelines should support deploying items organized in workspace folders when equivalent folder structures exist across stages. Currently, deployments can be blocked when items are ...majofv11 hours agoNew MemberNew5Views0likes0Comments