Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more

Reply
MrSnaggls
Frequent Visitor

Update combined tables without updating source tables

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!

1 REPLY 1
edhans
Super User
Super User

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.



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting

Helpful resources

Announcements
PBIApril_Carousel

Power BI Monthly Update - April 2025

Check out the April 2025 Power BI update to learn about new features.

Notebook Gallery Carousel1

NEW! Community Notebooks Gallery

Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.

April2025 Carousel

Fabric Community Update - April 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors