Forum Discussion
Direct Query for Power BI datasets and Analysis services. Publishing a report in Power BI Service
Hi I am having an issue when publishing a report in Power BI service. i've combined 2 power BI datatsets (both from workspaces i am Admin on) along with a excel using the new preview feature in ...
thanks Stefano, it appeared to be an issue with the excel file being local and the power BI datasets being in the cloud. Once i moved the excel file to sharepoint and created a web connection so everything was cloud based it worked fine
go over to the linage view of the workspace click that dataset at options and click configuration over the gateway section make sure it have a gateway associated to the dataset and that the gateway have enable the cloud base information access. looks something around there its the missing part.
