Forum Discussion
Export datasets from Power BI Service to CSV using VBA
Downloading a Power BI Dataset with VBA wasn’t really a thing I planned to do until Microsoft released the new PBI Usage datasets. In this article, I’ll describe the steps to export datasets from Pow...
Did as you described but found an error on GetString method. It says that adClipString is an undefined variable. When i replaced "adClipString" for "2", the value of the adClipString StringFormatEnum , it worked for a while. But recently it pops a "Method 'Open' of object '_Recordset' failed" error when i run the macro. Thx Anonymous for the amazing solution btw!