Forum Discussion
Solved
Refresh not possible after Join in Query
Hello all, i did a simple Table.NestedJoin of two tables in the Power Query and a Table.ExpandTableColumn (extended the table with two columns after join). Result is that in Power BI Service...
What are the data sources from the two joining tables? From my experience, certain mixed of data source types dont work.
Also, check the privacy setting for both joining tables/queries/data sources, just for testing, try setting both to "none". "Datenschutzebene" is mentioned in the error, this could be it.
Hi Tutu_in_YYC
the data sources are the same with the only difference being lowercase and uppercase. Adjusting that helped. Thanks!
Best regards.
interesting. We know that M is case sensitive, but SQL shouldnt. Anyway, good that its solved it.