Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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,
Solved! Go to Solution.
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.
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.