Forum Discussion

Salvador's avatar
Salvador
Responsive Resident
9 years ago

Storing and using information from a dynamic data source using PBI desktop.

Hello,   This is something that I've worked in for a couple of months, and have been successfully using it for 3 months, and now would like to share with the community. If you want to know where th...
Show and Tell
Tips and Tricks
Salvador's avatar
Salvador
Responsive Resident
7 years ago

Hello Koluman,

 

You can do the same with data from any source, since what you are doing, is capturing data that is already contained in your power bi desktop version.

 

The combine and edit appears if you select folder as your data source, if you select, for example, an excel, you will only have edit or load.

 

Regards,

Salvador.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Salvador   how does the 'HistoricalData' table gets created?.. it was not mentioned anywhere in the ps script or steps u created?

  • Salvador's avatar
    Salvador
    Responsive Resident
    7 years ago

    Hello Anonymous,

     

    It's explained in step 5, basically it's connecting to the folder where you are going to store the csvs that register the historic data.

     

    Regards,

    Salvador.

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Salvador does this method work with pbi service?  

      • Salvador's avatar
        Salvador
        Responsive Resident
        7 years ago

        Hi Anonymous,

         

        Yupp, but you have to make thoose csvs available to be uploaded onto the service, I used a data gateway ^^

    • cosminc's avatar
      cosminc
      Post Partisan
      7 years ago

      Hi,

      it was reinstalled Windows on my computer and i have an issue

      the script opens the power bi which need to be refreshed and to export but something don't work and rests opened

      below the PBI exporter log:

       

      Executing PBI_Exporter.ps1 at 2019-07-16_13_58_02
      Launching Power BI
      Waiting 30 seconds for PBI to launch
      Assuming PBI is launched and ready now
      Connecting to PBI using AMO
      Exception calling "LoadFile" with "1" argument(s): "The system cannot find the file specified. (Exception from HRESULT: 0x80070002)"
      The system cannot find the file specified. (Exception from HRESULT: 0x80070002)
      Script finished with errors at 07-16-2019_13_58_34
      Closing the connection
      You cannot call a method on a null-valued expression.

       

       

      any idea what i have to do?

      thanks,

      Cosmin