Hello, i need to add a Excel file as a source to a report that already uses one PBI data source . I have several questions:
the best way to do this is to publish the file to PBI Service, right? I’ve done it and PBI automatically also creates it as a datasource - so far so good.
shouldn’t this data source appear as such automatically on Power BI Desktop option PBI data sets? if it doesn’t appear should it be a matter of permissions?
can i add this 2nd data set to the report? Do i have to use that preview option: Directquery for Power BI datasets and AS?