Forum Discussion

david_blabla's avatar
david_blabla
Frequent Visitor
6 years ago

Query empty data set will lead to nothing is downloaded - How do I fix that?

Hi all,   For our use-case we are creating standard dashboards and reports connected to a couple of web APIs. We will set these up for some different clients at the beginning of their project. Sinc...
Need Help
v-juanli-msft's avatar
v-juanli-msft
Community Support
6 years ago

Hi david_blabla 

If your data has columns' names but has no value for each column, power query could read data into power bi.

But if there is no any information from your data source, power query would not read any data by default.

 

Best Regards

Maggie

  • david_blabla's avatar
    david_blabla
    Frequent Visitor
    6 years ago

    Hi v-juanli-msft,

     

    Thanks for you reply - When you say "power query would not read any data by default" does that mean that there is an option to make it load data even when there is no information from the source?

     

    It does not feel right to setup our endpoint in a way that it serves empty files without any content if nothing is to be shared yet. Can't I tell PowerBI to jump over an empty endpoint but continue to download the rest, run dashboards based on the available info!?

     

    Thanks,

    David