Forum Discussion

Quentin_'s avatar
Quentin_
Helper I
6 years ago
Solved

scheduled refresh csv + table combine Error ?

Hello,

I have a problem with the scheduled refresh for my reporting (It works fine on pbi desktop).

For 4 tables of my data model, I need to combine 2 csv (the csv are in a server and I call this files directly by url).

 

Each morning, I have the following message : "Information is needed in order to combine data Table: xxxxxx".

 

----------------

Example call for one combine table :

Table 1 -> Csv.Document(Web.Contents("http://www.xxxxx.fr/my_file_1.csv"),[Delimiter=";", Columns=8, Encoding=65001, QuoteStyle=QuoteStyle.None])

Table 2 -> Csv.Document(Web.Contents("http://www.xxxxx.fr/my_file_2.csv"),[Delimiter=";", Columns=8, Encoding=65001, QuoteStyle=QuoteStyle.None])

Final table -> Table.Combine({#"Table1",#"Table2"})

------------------

How I can solve this problem please ?

 

Thank you,

  • Hi Quentin_ ,

    After researching, I think it might be caused by privacy level. Please follow the steps to check it in Desktop and Service.

    In Desktop:

    File > Options and settings >Data source settings > Change privacy level to None or organizational

    In Service: 

    Manage gateways >Advanced settings

    Best Regards,

    Xue Ding

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

2 Replies

  • v-xuding-msft's avatar
    v-xuding-msft
    Community Support

    Hi Quentin_ ,

    After researching, I think it might be caused by privacy level. Please follow the steps to check it in Desktop and Service.

    In Desktop:

    File > Options and settings >Data source settings > Change privacy level to None or organizational

    In Service: 

    Manage gateways >Advanced settings

    Best Regards,

    Xue Ding

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