Forum Discussion
Get data from Power BI DataSet Import option? - Excel
Hi, I'm new here and would like to know if I can easily Get Data from a Power BI DataSet and use it in an Excel Data Model. Currently, I can create a DataModel in an Excel workbook and Publis...
Were you able to get this working? I'm trying to do the same thing.
Closest I can get is to Get Data → From Other Sources → From OLEDB, using the Power BI connection string. However, my permissions quickly expire, presumably because the OLE DB connection string doesn't allow the Integrated Security property, which *is* used in the Analyze in Excel connection ("Integrated Security=ClaimsToken;")…