The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hello everybody,
I have several tables imported with a custom connector. The data source is a company internal application.
As a key user I have the access rights for all the data and therefor I can update them all (and I also created the PBI).
In future the single tables have to be updated by different users, who only have access rights to the data for their table.
Table A = User A
Table B = User B
...
The tables are combined to a new Table "All tables". So I had the plan that each user may update their table and after that the table "All tables". For me, it was logical that there should be no problem here, because the table "All tables" might combine the data from the single tables in the current state.
But now we tested this and it seems that by updating "All tables" PBI does something with the single tables that needs the access to the server data which produces an error.
"Web. contents failed to get contents from 'https:// [...]' not found"
Is there any way to surpress this or tell PBI only to take the data as it is?
Any help is welcome. Thanks!
If the "All Tables" table is a Table.Combine in Power Query, it will need access to all child tables to work.
If "All Tables" is a union of the child tables in the source system, it should pull unless that table is more of a view in the source system.
But it is hard to tell. You have a custom connector and you've given us no info on the backend, and why there would be an HTTP request anywhere.
How to get good help fast. Help us help you.
How To Ask A Technical Question If you Really Want An Answer
How to Get Your Question Answered Quickly - Give us a good and concise explanation
How to provide sample data in the Power BI Forum - Provide data in a table format per the link, or share an Excel/CSV file via OneDrive, Dropbox, etc.. Provide expected output using a screenshot of Excel or other image. Do not provide a screenshot of the source data. I cannot paste an image into Power BI tables.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingJoin the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the August 2024 Power BI update to learn about new features.