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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

AugPowerBI_Carousel

Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

August Carousel

Fabric Community Update - August 2024

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

Top Solution Authors
Top Kudoed Authors