cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
BenCardineau
Frequent Visitor

Dataflow connecting to PWA

Hi all,

I managed to connect in PBI Destktop to the MS Project Online pwa (using the OData connection like in the template here). Nice. But now I need to do the same in a dataflow, but for some reason it doesn't work, my credentials not being recognised by the dataflow.

 

I am using:

- odata connection

- url sth like "https://mycompany.com/sites/pwa/_api/ProjectData/[en-us]", 

- organizational account as authentification kind

- no datagateway (as pwa is on the cloud, right?)

 

As any of you managed to connect to pwa in a dataflow, or do you have any idea why is worked in desktop and not in dataflow?

Thx for your help,

Ben

3 REPLIES 3
v-janeyg-msft
Community Support
Community Support

Hi, @BenCardineau 

 

Does the gateway clearly show that there is no need to configure the gateway? Do the credentials you use correspond to the credentials of the data source?

You can try to change other credential and authentication method.

If it doesn’t solve your problem, please feel free to ask me.

 

Best Regards

Janey Guo

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

nickyvv
Super User I
Super User I

Hi @BenCardineau,

 

I haven't worked with PWA, but a general remark:

Have you tried copying the M-query (so from the advanced editor in PBI Desktop) into a blank query in the dataflow and see if that helps? Just to make sure you have the exact same code and connectors in Desktop and online?



Did I answer your question? Mark my post as a solution!

Proud to be a Super User!


Blog: nickyvv.com | @NickyvV


Hi @nickyvv yes indeed I tried that but same result sadly... 😞

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.