My attached pbix file has a single data source of an SQL database, tables are loaded as direct queries but the reports also include import queries as I have created tables using DAX such as SUMMARIZE.
When publishing to the PBI Web Service only the visuals from the import query “tables” are visible not the ones from the direct query tables. ?!?!?!! I have set up a gateway connection to the data source and have attached the settings for you to see. The error message refers to permissions but I have read so many MS docs and blogs I don’t know where or how to fix this, hoping you can help.
Many thanks Lizzie
Daily KPI Dashboard.pbix (6.4 MB)