Forum Discussion

jaypatel's avatar
jaypatel
Helper 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
ImkeF's avatar
ImkeF
Community Champion
3 years ago

Hi jaypatel ,
the refresh behaviour is how Power Query is designed and to my knowledge, cannot be changed:
Once you reference a query in the PQ editor, the referenced query will also be refreshed. Even if it is set to "Don't include in report refresh".
You could consider moving the "New ATDS"-query into a dataflow and reference that DF instead. That wouldn't trigger the refresh then

jaypatel's avatar
jaypatel
Helper 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
    Community 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.