Forum Discussion

jaypatel's avatar
jaypatel
Icon for Helper III rankHelper III
3 years ago

Get Data from Exiting Power BI Dataset using API

In Power BI, I have a dataset with data that resembles Access token data. When I click "Refresh Preview," it updates. Every API has an expiration date restriction. In a Power BI situation, I need to ...
Need Help
jaypatel's avatar
jaypatel
Icon for Helper III rankHelper III
3 years ago

Hi ImkeF , 

I tried to add DatwFlow to get the "NewAt DS" dataset value in it and use the same value in the Child dataset. However, I was able to refresh the dataset on the Power BI Desktop version. Once I published on to the Power BI Service and check in Data Source Credentials, it give me an unauthorized access error. I tried with "anonymous" credentials as there was on pop-up showing that when we use REST API as a data source we need to Sign In with an anonymous user.

Please help me with this.

 

And another thing to discuss is Why I was not able to set up Gateway for Dataflow? 

Thanks in Advance,

Jay

ImkeF's avatar
ImkeF
Icon for Community Champion rankCommunity Champion
3 years ago

Hi jaypatel ,
not sure I understand what's going on here.
But if you have staged some data in the dataflow, you should be prompted to authorize with your (organisational) Power BI account.
Anonymus auth wouldn't work, as that would mean that everyone could access your PBI dataflow.
Auth towards your API might be anonymus, but this would only be relevant when refreshing the (staging) dataflow and not during the dataset refresh.